Search results

Dear vletm Thank you for your kind and productive solution. It both gave me a better idea to solve the problem and saved a huge amount of time :). Thank you. Kind regards. Ahmet K.

Dear Excel Gurus hi, I have a long list of a data that shows over 4000 of incident in different locations reported by close to different 1000 person. Each row has contact (person), location, problem, description and date of a specific issue reported. Now I have been asked to prepare a single...

Dear Etaf hi, Thank you very much for your kind reply and help. :) Best regards Ahmet K.

Dear Etaf hi, Thank you for your kind reply. At the attachment you may find the data sheet that I am working on. I have erased most of the data and just left one coloum due to confidentiallity. As seen. we have data all the way back to 2014 and the average formula simple averages values above...

Dear Excel Gurus, I have a bunch of sales figures for the last 10 year for different product groups. In order to forecast the following years stock and/or sales, we tend to take the average of each product group's last 2 years sales units and volumes. However from time to time we adjust our...

Dear Bosco, Thank you very much. Kind regards AK

Dear vletm, Thank you for your kind reply. Can you please also tell me the formula you have used to calculate sums? I also want to learn the calculation formula, especially the date part? Kind regards AK

Dear Excel Gurus, I have a list of payments and I have already sortted them out based on the departments and the suggested value of the payment that is corresponding to that department (data) I also made a short index file summarizing the sependings. I actually know how to sum different data...

Dear Bosco, Thank you very much. Kind regards. AK

Dear Excel Gurus, In our account deparment we keep track of all our customer payments they did with their credit cards. I have list that shows the entire transactions of the payments we have received from our customers credit cards. (please see the attached file) I want to take the sum value...

Dear Bosco, Thank you very much, you are life saver :) Best regards. AK.

Dear Excel Gurus, I get a list that I need to sort and prepare a list of expenses every month for our finance deparment. The data comes from our accounting deparment to me end of every month and the titles, desription, etc... are always same. (Please see the attached file, the date shown...

Dear Excel Ninjas, I have an excel file (please see the attached file) that I have prepared to estimate my monthly product based sales. Next to each product, I wrote the current stock level and monthly estimated sales figures (unit) My problem: I want to apply a conditional format that will...

Dear Hui, Thank you for your kind reply as well. Kind regards. Ahmet K.

Dear Paul, Works perfect, exactly what I needed :) Thank you very much for your kind and prompt help. Kind regards. Ahmet K.

Dear Excel Gurus, I have an excel file (please see the attached file) that I have prepared to follow up my sales team's country wide visits. Each sales rep enters the total number of customer visits they do at a certain city at a certain date. My problem: I can't find an easy way to bring...

I guess excel can't full fill my request for the moment :) Any picture that is inserted moves down as you scroll down the page and repeats itself. Anyhow thank you all very much for all your valuable comments. Kind regards. AK

Dear Hui and Sachinbizboy, Thank your for your quick replies. @sachinbizboy, having read what Hui said, I have realized that my request is not actually very logical due to printing. But anyhow I wanted to set a bacground and keep it fixed (stable) on the page as I go down the page as in some...

Dear Excel Gurus, I have set a picture as a back ground for my work sheet in excel 2007. As I scroll down the sheet, the picture also moves down and repeats it self as I go down the page. Question: I want the picture to be fixed and never to move. In other words to restrain or lock...

Dear Narayan, Thank you for your kind reply. Eventhough I have been told not to, I guess there is no other way but to use VBA in this issue. Having read many possible solutions they all somehow involve VBA, therefore I guess I have to step backwards and use VBA. Just have to convince my...

Dear Excel Gurus, One of my main task in my job is to follow sales reps visit plan and visit ratio. For a while I have done this through numbers and even had a related post “how to move horizontal date vertically” on this issue (if interested please see the blow link)...

Dear All, I solved it, thank you. {=INDEX(f7:f14,MATCH(MIN(ABS(f7:f14-g7)),ABS(f7:f14-g7),0))} don't forget to Press and hold Ctrl + Shift. Kind regards. AK.

Dear Excel Gurus, Every 3 to 4 year I search second hand car dealers & internet to find good deals. As always in order to find best prices I rely on excel :) I have a simple method: Write down all potentials, divide total KM with price, find per KM price per car. And also do the same for...

Dear All, I have completed my draft dynamic dropdown menu with multiple branches where you can keep selecting from different menus and can go on forewer. For the ones who are interested please see the below link: http://speedy.sh/Gj6ZH/cloth-finder.xls Kind regards. AK

Dear Bobhc, Thank you very much for your kind response & link. I have finally done it. :) Kind regards. AK