Search results

I know i am asking tooo much ... please tell me how do i filter specific name with one click ? for example i want to filter "Mr.x" with one click Or how d i make a button to filter a specific name?

Thanks. that works like i want... you really deserve "like" for each of post or comments and help Thanks again. CHEERS......

That works now Thankyou very much can you tell me how do i make one button to check all boxes in filter (for A colomn )

WOOOOOOOOOOOWWWWWWW thats working now Thanks a million

Ooops just updated

It actually filter using a text box appearing after clicking on the button instead of dropdown box (inbuilt filter) and check box for filtering the data, I have two files one is working and another one is in which i want to do the same. i filter the data using some vba code(someone did it for...

thanks

i am using excel 2007 and i dont find advance filter please tell me if i am wrong i have also attached sample file

i have too many customers and i filter them by checking the boxes(when we filter data) but now since they are now too many i want to make it easy and filter them by just tying thier name in some ind of search box or some kind of hyperlink or anything which can filter data easily

Hi faseeh ramzan mubarak! you helped me in my thread almoast one year back. you are my hero !!!!

it worked THANKS luke.

i have to autosum a column but it has formulas in it =INDEX(Sheet2!L5:L24,MATCH(nuru!B5,Sheet2!M5:M24,0),0) i want autosum it i get error #N/A how can i get autosum???

=IF(B3:B13=$L$1,A3:A13,"") i have got this simple formula but it leaves spaces when customer name does not comes (L1 is customer name's cell)

is it possible to use different formula for each column? i dont want to use array formula, also it hard to understand how it works.

Hi, faseeh i was just looking at the formula by selecting random cell and click in formula bar and when i click outside the cell ,the cell goes blank! it is happening every time in each cell when i click in formula bar. what actually i have noticed, whenever i click in formula bar and click...

hy faseeh in your file the date is not visible. instead of date there is customer name!! can you plz take look???

oh faseeh! you made my day THANKS. it is such a relief to get replay like you does THANKS again... Thanks to all

Hi, faseeh your idea did not for me also i can not drag it but only vertical or horizontal only BTW what b1 and d11 is doing there i dont get it finally i want some detail how to grag it to j13??? @vijay i am just looking at your idea Thanks for all your help

http://speedy.sh/8Jjse/test.xlsx

i want to fill some data to be filled automatically but i am not getting the formula. here is what i want... when i write customaer name in sold field (b3) all the entry should automatically be filled (g3 h3 i3 j3)in his creadit account from (a3 c3 d3 e3). somehow i managed to get it...

it worked thanks to all specially faseeh now i understand how index match works. Thanks again

i think index&match should work but i am no getting the formula(i am new in it) here is the image here is what i want in it.. i use one sheet and devied it into two section(bought and sold) i want> when i type unique no in sold section, the other fields(in sold section) should...

i think index&match should work but i am no getting the formula(i am new in it) so here is test file http://www.2shared.com/file/fdbeMfxz/nicholes.html and here is the image http://postimage.org/image/6vckcetl1/ here is what i want in it.. i use one sheet and devied it into two...

i think index&match should work but i am no getting the formula(i am new in it) so here is test file http://www.2shared.com/file/fdbeMfxz/nicholes.html and here is the image http://postimage.org/image/6vckcetl1/ here is what i want in it.. i use one sheet and devied it into two...

i think index&match should work but i am no getting the formula(i am new in it) so here is file http://www.2shared.com/file/fdbeMfxz/nicholes.html and here is the image http://postimage.org/image/6vckcetl1/ here is what i want in it.. i use one sheet and devied it into two...