Excel Help and Problems

[etech0]

This is the formula I am using in one of the cells. If it returns a positive number I would like it to be in green and a negative number to be in red. Can it be done?

=SUM(M2:M7)-SUM(M8:M10)-M16

Sure, with conditional formatting. You'll want to set up 2 rules, one for Greater Than 0 and one for Less Than 0.

[yoruel]

Excel Formula for Cell Comparison. Looking to see % of incorrectness.

[Definitions]

Excel Formula for Cell Comparison. Looking to see % of incorrectness.

assuming you mean this https://www.calculatorsoup.com/calculators/algebra/percent-change-calculator.php

Cell A1 is number 1
Cell B1 is number 2
Cell C1 is the difference of number 1 to number 2

Then do in cell C1:
=((B1-A1)/A1)*100

(Percentages always confuse me. if someone can explain the two types of calculators in the link above (percentage change and percentage difference) it would be greatly appreciated)

[yoruel]

I have in A1 text 25 in B1 I have text 26. =A1=A2 will be false.
What % of A1 & A2 are the same?

[skyguy918]

I have in A1 text 25 in B1 I have text 26. =A1=A2 will be false.
What % of A1 & A2 are the same?

This is extremely difficult to do in Excel. Possibly doable in VBA, but it wouldn't be simple. This is a similar, though you'd need to know how to use their code to set up a macro to get it to work:

https://www.extendoffice.com/documents/excel/3716-excel-compare-two-strings-highlight-differences-for-similarity.html

[Definitions]

I have in A1 text 25 in B1 I have text 26. =A1=A2 will be false.
What % of A1 & A2 are the same?

Meaning you want to see the percentage of characters that are the same?
Is there a limit to how long a string is (if yes how long)? Are the two strings always the same length?

[lubaby]

I have in A1 text 25 in B1 I have text 26. =A1=A2 will be false.
What % of A1 & A2 are the same?

This?

=COUNTIF(C1:C10,"true")/COUNTA(C1:C10)

[yoruel]

Meaning you want to see the percentage of characters that are the same?
Is there a limit to how long a string is (if yes how long)? Are the two strings always the same length?

No limit. They are jot the same.

I found a macro.

Similarity.  I think I got it

[yoruel]

This is extremely difficult to do in Excel. Possibly doable in VBA, but it wouldn't be simple. This is a similar, though you'd need to know how to use their code to set up a macro to get it to work:

https://www.extendoffice.com/documents/excel/3716-excel-compare-two-strings-highlight-differences-for-similarity.html

This may work. This is the concept.

[unavailable]

Hi
Looking for someone that can help me create an excel sheet that can combine multiple reports into 1.

Let's say I own 4 store locations and they are run in separate QuickBooks files. QB creates the report for each location. How can I combine all into 1 report. It is complicated by the fact that the locations don't have the same exact items(lines), ie a few expenses only apply to some locations. So I can't just do c/p.

Any suggestions,
thank you 

[yoruel]

Try putting the 4 reports on 1 sheet, ON 4 SEPARATE TABS.
Right click the tab name>copy> make sure you put all onto the same sheet
.

In new tab you can copy headers, then for rest of report you can copy the data a2 = sheet1!a12 ETC

[unavailable]

if I understood correctly this would work fine if the reports were the same.
but with different lines on each report, I cant copy the entire data c/p.
Of course I could do cell by cell, but then what good is excel.

[Yisroel Tech]

If I understand correctly this would be a human question not an Excel question.

While you might get Excel to pull data based on what you decide should be the same, you obviously cannot tell Excel to "do what's in my head."

So you need to logically map out in your mind what you want the report to look like, and based on that you (or someone can help you) pull the correct data from all the sheets as needed.

[Yehudaa]

Hi
Looking for someone that can help me create an excel sheet that can combine multiple reports into 1.

Let's say I own 4 store locations and they are run in separate QuickBooks files. QB creates the report for each location. How can I combine all into 1 report. It is complicated by the fact that the locations don't have the same exact items(lines), ie a few expenses only apply to some locations. So I can't just do c/p.

Any suggestions,
thank you 

I don’t know enough to provide particular advice, but this sounds generally like something that a macro might help with. If nothing else, you may be able to create a macro to add zero-dollar lines for the line items that don't appear on a given sheet, and then either c/p via macro or do that part manually.

No personal experience actually using macros, but I’ve heard they’re useful for such situations. Maybe look into hiring someone to create the macro and teach you how to run it.

[unavailable]

yes, I'm looking for someone that can create/teach me how to.

Willing to pay.

[farmbochur]

Hi
Looking for someone that can help me create an excel sheet that can combine multiple reports into 1.

Let's say I own 4 store locations and they are run in separate QuickBooks files. QB creates the report for each location. How can I combine all into 1 report. It is complicated by the fact that the locations don't have the same exact items(lines), ie a few expenses only apply to some locations. So I can't just do c/p.

Any suggestions,
thank you

https://youtube.com/shorts/NRMYxNQxN6s?feature=share4

[avadah]

Hi,
I'm trying to figure out a formula that if value x or y or z appears in column a or column b i want the sum of column c minus column d and value x may appear numerous times in the column so i want the total of those sums. (sorry if im not clear)
Thanks

[aygart]

Hi,
I'm trying to figure out a formula that if value x or y or z appears in column a or column b i want the sum of column c minus column d and value x may appear numerous times in the column so i want the total of those sums. (sorry if im not clear)
Thanks

Not able to test but I would try this.

=if((or(A1,B1)=or($X$1,$Y$1,$Z$1)),(C1+D1),(what you want to appear if it is not there))

Don't understand the last part

[avadah]

Don't understand the last part

Looking for the sum of all the (c-d) that have an xy or z in the row, not 1 particular row

[yoruel]

That should be a standard SUMIFS.