return multiple records matching multiple criteria
Hi All,
I have a worksheet with the following data in Sheet1 Col A Col B Col C Ram ABC Hi-Hi Ravi CDE Med-Med Ban ABC Hi-Hi ASt ABC Med-Med Son CDE Hi-Med In Sheet2 A1 has a value from ColB i.e, ABC B1 has a value from ColC i.e, Hi-Hi I need the formula to display the matching records of ColA i.e, Ram Ban Similarly if the values A1 and B1 of Sheet2 are changed to CDE and Med-Med it should display Ravi I donot want to use advanced filter or Pivot tables Thanks in Advance Karthik |
return multiple records matching multiple criteria
You could use DataFilterAutofilter or Advanced filter
HTH -- AP "Karthik" a écrit dans le message de oups.com... Hi All, I have a worksheet with the following data in Sheet1 Col A Col B Col C Ram ABC Hi-Hi Ravi CDE Med-Med Ban ABC Hi-Hi ASt ABC Med-Med Son CDE Hi-Med In Sheet2 A1 has a value from ColB i.e, ABC B1 has a value from ColC i.e, Hi-Hi I need the formula to display the matching records of ColA i.e, Ram Ban Similarly if the values A1 and B1 of Sheet2 are changed to CDE and Med-Med it should display Ravi I donot want to use advanced filter or Pivot tables Thanks in Advance Karthik |
return multiple records matching multiple criteria
I had stated that i donot want to use Advanced filter.
Thanks anyway |
All times are GMT +1. The time now is 07:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com