| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Incrementing Rows or Colums After Running Through an IF Statement
I am trying to check two lists of names against each other. I would like to
check the first name in list one against all of list two. Once that is finished I would then like to increment to the next person in list one and repeat the process. Is there a way that I can set the number after a column (A"#") as a variable that I can change? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Incrementing Rows or Colums After Running Through an IF Statement
Suppose you have the two lists in Col A and ColD and you are comparing each
name in Col A with ColD. In col B CELL B1 place the formula =IF(COUNTIF(D:D,A1)0,"Present in List","") Once done. copy the formula down to colA...The formula will adjust for each name in Col A.. If this post helps click Yes --------------- Jacob Skaria "Intern" wrote: I am trying to check two lists of names against each other. I would like to check the first name in list one against all of list two. Once that is finished I would then like to increment to the next person in list one and repeat the process. Is there a way that I can set the number after a column (A"#") as a variable that I can change? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SumIf statement: incrementing | Excel Worksheet Functions | |||
| fill down formula incrementing by every 12 rows | Excel Discussion (Misc queries) | |||
| Print few rows with many colums so that rows wrap on printed pages | Excel Discussion (Misc queries) | |||
| Incrementing formula by two rows | Excel Worksheet Functions | |||
| Automatically 'incrementing' formulas for new rows. | New Users to Excel | |||
Hybrid Mode
