Welcome to the forum.

Are you entering =IF(B3:B13=$L$1,A3:A13,"") into an array range? I think it would help us if you mocked up an example spreadsheet and attached it to the thread for us to see. If you're asking for what I think you're asking for then, yes, it is possible to do it with formulas but it is not simple and there are better alternatives. I'll reserve my recommendation until I'm 100% clear on exactly what you need.

ok i have attached a file and here is what i want...

i want to get rid of those blank spaces (in E4,E5) is there any easy way that i can understand too?

EDIT:-can i ask one more thing in in same thread(off topic for this thread)

how do i fill same data in other cell?

for example if i type date in A1 and i type price in B1 .. now i want this enter of A1 and B1 should also go automatically in sheet 2(in A1 B1) and in sheet3 (A1 B1) as well. HOW TO?

Attached Files

temp.xlsx (9.6 KB, 12 views)

Hi nicholes,

why don't you just filter the data using an autofilter?