Lookup all values on next tab

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CGDorn - 14 Nov 2007 21:20 GMT

Suppose I have some data and an if function in Column A. The If function
returns a "Yes" if 4 sets of criteria are met. If on another tab I want to
import all data with Yes in the A column into the new tab and I do not want
spaces between rows.

For example, in column A says if(and(D1=1, E2=1, F3=1, G4=1),"YES","") and I
want the other tab to dispay all the information from columns B, C, D, E, F &
G. Can this be done? Thanks in advance

Reply to this Message

Farhad - 14 Nov 2007 21:54 GMT

Hi,

I think the easiest way is to autofilter the column A on "YES" and then
select the filtered data and copy and paste in other tab.

Thanks,

Signature

Farhad Hodjat

> Suppose I have some data and an if function in Column A. The If function
> returns a "Yes" if 4 sets of criteria are met. If on another tab I want to
[quoted text clipped - 4 lines]
> want the other tab to dispay all the information from columns B, C, D, E, F &
> G. Can this be done? Thanks in advance

Reply to this Message