greatly

Firstly, apologies for how the data appears on here I am trying to calculate the total sum of X.Y or Z for all section A and B For example A - X should = 29, Y = 15, Z = 24 The formula I have used only returns the sum for column I and not all columns I, II, III, IV, V...

Hi Everybody, I'm looking for a formula to put in column C that will display the lowest price from each row in column A and B. Some of the cells contain "N/A" so I want to make sure it doesn't return an error. I greatly appreciate any help you can give. Example: <tbody> A B C N/A 11.49...

I have a spreadsheet with multiple sheets. I am trying to set it up so if sheet 2 D30 has a value, a row auto inserts on sheet 1 line 4. I have been looking for a while and can't find anything that does what I need. Any help would be greatly appreciated.

Guys, Badly need a formula to get the next quarter date for a given date Column A1 date is June 1, 2017 (by quarter) Column A2 for the year 2018, it should should be Feb 1, 2018, what formula should i arrived at that? Column A3 April 1, 2018 so on and so forth Any help will be greatly...

Morning/afternoon/evening all I have created an excel sheet that contains a table full of data which i have added a graph at the bottom of the table (small size) but i would like to be able to click on the graph and for it to open up in a new sheet and view it on a larger scale which the option...

Here at work we are on the hours and tenth's hourly clock. I can not find a formula to convert hours and minutes into hours and tenths. Any help would be greatly appreciated. Along with Thank you in advance. Kevin

<tbody> Letters amount a 5 c 10 b 2 a 10 c 10 b 1 b 1 b 1 a 10 </tbody> Hello Everyone, What i am trying to accomplish is to run a CALCULATE function in conjunction with sum to always sum up the totals of its specific letter. In addition, I would like a= 25, b=5, and...

Hi All, I have been passed two sets of data. O ne is a list of ID numbers with Dates of Birth in the second column. The other is a list of ID Numbers with Names on. Ideally I need to merge the two so that I have 3 columns, which are Id Number, DoB & Name. Any help would be greatly...

I received a employee file where the data was formatted differently than how I need for the report I am creating. I essentially need the cells to shift columns to realign to the right. The report currently looks something like this: A B C D C D D and I need to create something that looks...

I don't know why I'm making this so difficult, I simply want the following. If the date in cell B9 = a date in January, say 01/09/2017, return a 1 in cell A9. If the date in cell B10 = a date in May, say 05/25/2017, return a 5 in A10. Column B is full of dates. Is this harder then I'm...

Hi all, I have a data export that provides the date as MMM DD, YYYY. Because of this format it is not being recognized as a date that I can convert to MM/DD. Does anyone know of a way to convert something like Aug, 15, 2017 to 8/15? Any help would be greatly appreciated. Kyle

I have a column of numbers not in consecutive order or together. I want to add the number 1 to all the numbers in that column but not into the blank cells in between the cells that have numbers. There could be 6, 8, or 12 blank cells in between and there are 70 cells with numbers that need...

Hi, I'm trying to manual calculate an adjusted cost base from a large list of stock transactions for different securities =IF(A3=A2,IF((E3="BUY",J2+I3,IF(IF(E3="SELL",J2-(F3*L2),I3) I'm trying to use the above formula but it keeps returning "false" instead of I3 when a3 does not equal a2 I...

Hi I have a nested IF string that is not calculating, any help would be greatly appreciated. =IF((AND(B5=AE12,AE13,AE18,AE19,AE25,AE26,E8>=2.251,E8<=2.55)),12,0)