Search results

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 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 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 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 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 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...

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 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 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 Excel Gurus, I am not sure whether if I have titled my search correct but please allow me to explain what I am trying to do. You know how on certain web pages while you are doing a search for a certain item, it first starts with a main drop down menu ex: "car & real estate" and as you...

Dear Excel gurus, A TODO list is smth that I have been using for quite some time both for my personal and business life. In my TODO lists I don't rank TODOs as "high" "medium" or "low" but instead sort them all. Meaning if there is 15 things to do in my TODO list depending on the importance...

Dear Excel Gurus, I am a big fan of your page and thanks to you I have learned alot from this page. My question may be quite easy for you guys but I have been searching for a solution for this problem quite some time and I still couldn't find a quick one. I made a list where I have...