cakjsingh2011

New Member
Joined
Feb 8, 2012
Messages
2
I have a spreadsheet with following columns -
User ID
Age
Height
Body type
Complexion
Diet
many other like this

I want to create a database such that, For E.g. if someone selects age between 23 to 26 and height 5.6 to 5.9, body type as average, then it should pick all filtered data (as per criteria) on main sheet. Plz advice how can i do it? Applying vlookup or hlookup is not sufficient. I need something advanced.
Please reply ASAP.
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

look

Board Regular
Joined
May 22, 2008
Messages
99
Hi cakjsingh2011,

Creat list

1 Need header

2 No empty rows

3 each item in separate colum

4 Use data filter

Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,118,121
Messages
5,570,306
Members
412,318
Latest member
angoeyuan
Top