| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match columns to rows then loop.
I am trying to match numbers in sheet1 column A to rows in sheet2 (row
3),then if there is a match find the last number in the column that matches(sheet2),if that is above 5 then enter 1 into sheet1 column b next to the value that has been matched eg sheet1!A1 = 123 (needs to be matched in sheet2) sheet2!C3 = (matched number) 123, find last value in column c if last value in column c is greater than 5 then sheet1!B1 = 1 then loop through all rows in Sheet1 column A any help is greatly appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match, then Look Left 4 Columns, then Loop to End of Range | Excel Programming | |||
| Loop through table of columns and rows | Excel Programming | |||
| Loop through columns and then rows | Excel Programming | |||
| counting the rows that match in my loop | Excel Programming | |||
| How do I delete rows and columns in With With End Loop? | Excel Programming | |||
Threaded Mode
