Repeat matching data

Karen · Apr 8, 2004

If data in column A matches data in Column C then I want
to repeat the data into Column H.

Frank Kabel · Apr 8, 2004

Hi
enter the following in H1
=IF(A1=C1,A1,"")

Peo Sjoblom · Apr 8, 2004

=IF(A1=C1, A1,"")

copy down

Karen · Apr 8, 2004

Thank you.

-----Original Message-----
=IF(A1=C1, A1,"")

copy down

--

Regards,

Peo Sjoblom

.

Karen · Apr 8, 2004

Thank you.

-----Original Message-----
Hi
enter the following in H1
=IF(A1=C1,A1,"")

--
Regards
Frank Kabel
Frankfurt, Germany

.

Matching Data	1	Mar 10, 2010
sorting data	2	Mar 25, 2010
matching & combining data from seperate worksheets	2	May 10, 2010
With F1 value, look at A, if match or partial match return B	5	Jan 19, 2015
COUNT COMMON DATA	3	Feb 2, 2009
SUM - IF - AND	7	Feb 21, 2018
match and sort two different tables	2	Feb 3, 2010
Convert Number to Text for Index/Match	1	Oct 31, 2012

Ask a Question