Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I read cell value and compare it with other cell in a colum
I want to create a macro in a spreadsheet that has been sorted in column H.
I want to put in 2 blank rows between different groups of data and then sum up the value of that data in column J for that group in the 1st blank row that was created. I think this means reading the information in cell H2 and comparing cells down the column until it does not equal the value in H2. I want to then insert 2 blank rows and them sum up the values in column J for that group on the 1st blank row that was created. I want to retain the column H information and then compare it down the column and repeat the process. Does anyone have a sample I can use? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare text string of a cell in Column A VS another cell in Colum | New Users to Excel | |||
Compare text string of a cell in Column A VS another cell in Colum | Excel Discussion (Misc queries) | |||
Compare text string of a cell in Column A VS another cell in Colum | Excel Worksheet Functions | |||
How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
lookup in colum a and compare values in colum b | Excel Worksheet Functions |