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