| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how can i filter from two rows?
Hi all,
I've two rows with properties addresses and i need to filter them out in third row in a way that any property which is not shown in row one appears in row three.say for example: Row 1 Row2 1 Confier Court 1 Berbris court 10 East Ham 3 East Ham 1 ABC 1 ABC 3 East Ham Now since 10 east ham is not showing in Row 2. I want this shown in 3rd row. Can anyone please help me on this? Thanks in advance. Cheers |
|
#2
|
|||
|
|||
|
Hi
as a starting point: http://www.cpearson.com/excel/duplic...#InOneNotOther -- Regards Frank Kabel Frankfurt, Germany "Ali" schrieb im Newsbeitrag ... Hi all, I've two rows with properties addresses and i need to filter them out in third row in a way that any property which is not shown in row one appears in row three.say for example: Row 1 Row2 1 Confier Court 1 Berbris court 10 East Ham 3 East Ham 1 ABC 1 ABC 3 East Ham Now since 10 east ham is not showing in Row 2. I want this shown in 3rd row. Can anyone please help me on this? Thanks in advance. Cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple rows of data on a single axis (charting) | Charts and Charting in Excel | |||
| Unhide rows | Excel Discussion (Misc queries) | |||
| Advanced Filter: No Filter | Excel Discussion (Misc queries) | |||
| interchange columns with rows | Excel Discussion (Misc queries) | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Linear Mode
