easiest

I'm trying to merge data from a weekly report into a master sheet that runs calculations. The weekly report is always formatted the same, and the calculation sheet will be as well. What's the easiest way to import data from the report to the master? I.E. F33 on the report will always need to...

I have a sheet as below with several dozen columns and thousands of rows. I want to join each column separtated by a / and a space. They are set out like below but if i do a normal concatenate formula I could end up with row 2 something like 8E0145806Q/ / / / / /. Row 4 is what how I would like...

In column A I have all the days of the financial year, in column M I have my daily takings for each day. I would like to be able to have a total for each month, what’s the easiest way please?

Hi, I am looking to convert 15 minute data to 30minute data as below (for 1000s of rows): <colgroup><col><col span="3"></colgroup><tbody> 1/01/2019 8:15 1801.669 1/01/2019 8:30 3602.79 1/01/2019 8:30 1801.121 1/01/2019 9:00 3606.543 1/01/2019 8:45 1803.261 1/01/2019 9:00 1803.282...

Hello, Got an Excel problem I'm struggling to solve. I need to be able to count the number of Numbers in a cell. So if a cell contained the text 23,24,25 The output would be 3 Is there a way to do this? I suppose the easiest way would be to count the commas? but.. there may be entires with a...

<tbody> Dropdown (Month) Amount Jan/19 Feb/19 Mar/19 Apr/19 May/19 Jun/19 Jul/19 Aug/19 Sep/19 Oct/19 Nov/19 Dec/19 Mar/19 1000 1000 </tbody> Hello, what would be easiest formula to pull the "Amount" in B2 to appear in the correct month from C2:M2 ? Thank you...

Hi Everyone - This might be explained easiest by the sample table below. I'm looking for a formula that will take my inputs (Month & Year) and return the value from the last available date in that month/year from the table. <tbody> Month: 3 Year: 2013 NEEDED FORMULA: 1563...

Whats the easiest way to copy and paste cells on this site so that someone seeing them can copy and paste them to his excel? Btw are attachments allowed?

Hi all, I don't understand macro at all but I want to learn it. Can you pls let me know the easiest way to learn macro online? Thanks for the help in advance. Regards, Harshad

Hi, I have a file saved on a server that people regularly are supposed to fill out. The data to be filled comes in multiple time horizons: Yearly, Monthly, Quartely etc. The people filling it out are probably worse in Excel than me, so I just wonder what would be the easiest way to expand the...

I am trying to populate fields in excel using data from access. What is the easiest way to accomplish that?

I am attempting to design my own calendar template since the ones that I have found are not what I need. I have a couple of questions Is there a way to enter in the days of the week with a formula or is it easiest just to type them in? is there a way to put the dates into a month at a glance...

I have a column with 27 unique names (criteria). There are tens of thousands of rows for each name. Of course, each name has adjoining columns with other data. I need to randomly select 200 rows for each name. What would be the best or easiest method to go about doing so? Thanks in advance...

Hi all. I have an Excel spreadsheet that includes a person identifier, which is a 7 digit number. I want to be able to anonymise the person id, so that it can still be used for sorting. What would be the easiest way to do this?