Transform data in excel
Hi Recently, my client has shared raw data, which I have processed a bit (attached here for reference). The workbook has 2 sheets: 1. Raw Data 2. Converted Data I have data in the format provided in Raw Data sheet and want to get the data in format provided in Converted Data sheet. Is it possible in excel to get the data in the desired format
Overwhelmed trying to resolve this.
Hi, I have a list of counties and the assigned rep for that county. I then have a fill rate report by county. I am trying to get a formula that will compare the counties then pull the name of the assigned rep into a column on the fill rate report by county. Its late, I've overthought this. Now I am hoping someone sees a simple answer to this. Thanks!
DATA ANALYSIS HISTOGRAM FUNCTION 'MACRO'
I am doing a repetitive task use of the Data Analysis Histogram function on #4 sheets within a workbook - I am seeking is it possible for an automating of the process - which produces a Histogram Result from a bin Range of a Colum of Data. In each case, I need to press the Data Analysis, select histogram, enter the Input Range, Bin Range and Output Range (selecting a cell) each data piece of which are the same for all #4 sheets. On each sheet I open the above enter the data and press 'OK'. I step through each sheet and this takes about 2-3 mins, but would be great if its possible to write a Macro or press one button. Any ideas would be amazing. Thank you.............