| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling an column/row Data from one sheet- another if critria is m
I have a formula that is pulling duplicates (thanks to help on this board).
I was wonedring if Sheet 1 and Sheet 2 have Duplicates can I have data that is on sheet 1 (in column C1) pulled onto sheet two in the duplicated row? Formual in Sheet two reads =IF(ISNA(MATCH(A1,SHEET1!,A:A,0)),"UNIQUE","DUPLIC ATED") how can I get some data in sheet 1 that corresponds to that Duplicate to appear in Sheet 2 as well....anyhelp? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pulling an column/row Data from one sheet- another if critria ism
I've just replied to your earlier thread, Ted - look there.
Pete On Jan 30, 10:34*pm, Farmer Ted wrote: I have a formula that is pulling duplicates (thanks to help on this board). * I was wonedring if Sheet 1 and Sheet 2 have Duplicates can I have data that is on sheet 1 (in column C1) pulled onto sheet two in the duplicated row? Formual in Sheet two reads =IF(ISNA(MATCH(A1,SHEET1!,A:A,0)),"UNIQUE","DUPLIC ATED") how can I get some data in sheet 1 that corresponds to that Duplicate to appear in Sheet 2 as well....anyhelp? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling specific data from a sheet | Excel Discussion (Misc queries) | |||
| Pulling Data from another sheet | Excel Discussion (Misc queries) | |||
| pulling data from one sheet to another | New Users to Excel | |||
| pulling data from another sheet | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Hybrid Mode
