RayH -
My name is amit and i am having problem with creating a excel sheet which has three columns stating date , service and amount. and now i want to buil it in a such a way that whenever when i want to search by the service name it should return all the vAlue of the specipic service name .
for example if i have given a service name data recovery and have served many customers in one year now i want to retireve all the datas under coulmn data recovery. how can i do that plzz do let me know . thankyou

1 reply

Apply a filter to the range and then select what you want to see.