Search results

Thanks So much DEB!! u saved the day!!

Hi, I have found this VBA on auto filter. however after the display, it comes out with the "=" at the front. Is there a way to remove the "="?? below is the Code: (Sorry i'm zero knowledge on coding) '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Function...

Hi Jason, Sorry Filter should be the right word. I actually tried Luke's way and it sort of partially worked. To clearify abit more, under the company name, ie, Company A, B,C,... through out the table there might be more than one Company A. After I selected the Filter for Company A, there will...

Hi Luke, I finally tried it and for some reason, it only work for the first 2 colomn of the name, if i extend the helper column to more then it only shows the last company name. for example, compnay A (A6) at the helper colomn i typed "=subtotal(103,A6)", and Company B(A7) at helper colomn i...

Thank you Luke for your quick reply. Very sorry about this I'm new to excel. When you say helper column, what does that mean? so my understanding right now, my company name is on Col A3:A10, the helper column is a list of all the compnay name i type out extra? Thanks

Thanks SirJb7, I will use the search function next time, sorry i'm now to this website still trying to learn how to surf thogh this. Thanks again.

Hi, I have a speadsheet with titles such as Name, date, telephone numbers, company name.... I have applied filter on the titles and sorted by company name. On the top of the spread sheet, I want to have a cell that shows the Compay name that I have sorted.(this cell is not static). What i mean...