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 |