Multiple times per month I receive an excel file. The file contains multiple tabs. Each tab contains datasets by column A-AH, which signify the region and by rows 1-40, that signify the product. Each cell contains the price of the product (Row 1-40) by region Column (A-AH) What I need is to have a reusable sheet or formula that will analyze all of the columns and rows and then give me a break down of which columns and rows share the same price. Giving a little back ground on what I do with this data. I currently take the datasets and look over them manually, determine which data sets are the same and then enter them into a program that later displays the data to my clients in their management system. I am looking to reduce the time it take me to manually inspect these data sets, and then group them together by their variation in price and geography ( typically there are 3-4 price variations in each row (product) for all 40 columns (geography).
44 freelancere byder i gennemsnit $122 på dette job
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
hello, i am interested in your project. i'd love to help you create the hi end excel analyse you are looking for. i will need some more details over chat. waiting to hear from you, thank you.