![]() |
Lookup all values on next tab
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 |
Lookup all values on next tab
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, -- Farhad Hodjat "CGDorn" wrote: 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 |
All times are GMT +1. The time now is 02:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com