| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Checking if information in a cell is within a column
In Sheet2,
Put in A1: =IF(Sheet1!A1="","",IF(COUNTIF(Sheet1!$A$1:A1,Shee t1!A1)1,"",Sheet1!A1)) Copy A1 down as far as required. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Andrew M." wrote: I have two sheets open On the first sheet, there is a single column of information. On the second sheet, there is a single column of the same formula. My question is what should the formula be if I want the second sheet's cells to show the first sheet's information, but only if there is not the same information in any of the cells above it? If there are any cells that already hold the information, future cells should remain blank or "". An Example... Sheet 1 Column A Row 1 - "SS-DFC-4" Sheet 1 Column A Row 2 - "S-DMC-5" Sheet 1 Column A Row 3 - "SS-DFC-4" Based on the above information sheet 2's Column A Row 1-3 should look like... SS-DFC-4 S-DMC-5 "" Could i get some help on how to go about writing this formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA: For Count, when count changes from cell to cell | Excel Discussion (Misc queries) | |||
| insert date | Excel Worksheet Functions | |||
| run a macro in a locked cell | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
Threaded Mode
