Thread
:
Filtering data to another sheet
View Single Post
#
4
Max
Posts: n/a
Perhaps better to TRIM the input from Sheet2's X1 as well,
so put instead in F1 in Sheet1, and copy down:
=IF(TRIM(C1)="","",IF(TRIM(C1)=TRIM(Sheet2!$X$1),R OW(),""))
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
Reply With Quote