Search results

How would I do a sumif function with index match. I have several sheets of data and I want the results to appear on a main table. See example below: Item number Quantity Each sheet has an item number with a quantity. Each sheet represents a location. Each location has several items some...

I need to highlight cells in one column when two cells in separate columns match in Excel 2003. I tried doing a conditional formatting formula is: =match($A1,$B1,0) while in the cell I want highlighted when that condition is true. & Excel gives me an error saying not enough arguements.

Oh thank you, so sorry about being rude, I thought related topics all went in the same thread. Sorry, again. I will start a new thread from now on. :) Thank you for your help. ~D.

I have a formatting question. I am trying to use the Match function with conditional formatting in Excel 2003. I 1st named my columns then put in the formula is box =MATCH(NAME1,NAME2,0) and put in the formatting I wanted but it highlights all the cells as if they all matched which they do not...

Everytime I try to hide a bunch of rows on this one spreadsheet I keep getting an error saying "Cannot shift objects off sheet." I can't figure out why. Can anyone help me with this? I have never seen this error before when just simply trying to hide multiple rows. Thank you, Dee