figures

Hi, (I'm using Excel 2010) I have a column of figures that are being constantly updated from a source that the spreadsheet is connected to. (In Column C) In column D I want to display the difference when the figure changes compared to what it was previously, every time that it changes. ie...

Hello, I have few figures arranged in row. In columns 1 i have a figure for reference and I want to highlight figures from columns number 2 to 9 in such a way that summation of those highlighted figures from columns 2 to column under consideration shall be less than figure in column number 1...

Morning all Some help needed please - seems pretty simple but it's beyond my Excel knowledge!! Data, as follows <tbody> A B C D E 1 12 3.1 2 2 2 24 3.2 2.5 2.5 3 36 3.3 3 2.75 4 48 3.4 3.75 3 5 60 3.5 4 3.25 6 72 3.6 4.5 3.5 7 84 3.7 5 3.75 8 9 36 3.5...

Hi. I have been having a browse for an answer to this question, but my solutions aren't working. I have 12 tabs with figures, & a 13th tab with totals & average. The calculation for the total is below, but I would like a 2nd box to give me an average across the same 12 figures but only counting...

Hi Guys i have this formula =IF(D9<>"",D9-G9-H9) ive also tried it with this =IF(D9<>"",SUM(D9-G9-H9)) D9 is blank but its returning FALSE instead of blank there is no formula in it only figures i input when needed as its part of a monthly accounts spreadsheet, any advise appreciated thank you

Hi everyone, So I have a list of names and figures on A:A, B:B respectively as well as C:C, D:D and I want E:E to match names from C:C to A:A and return B:B figures. The problem is that names are repeated on both lists on many occasions with different figures attributed to them. How do do an...

If I have the following data set: .....A... 1 2.9 2 0.7 3 -0.8 4 -2.5 In cell A6, I want to sum all of A1 thru A4 and average it out =SUM(A1:A4)/4 but...when I add another row of figures at the top of the set and delete a line of figures at the bottom of the set, for example, now I have...

Hi, I am trying to create a SUMIF based on a date. The Date is based in Sheet 1, Cell C7 and the 12 options that can be input are May 18 through to Apr 19. In Sheet2, Cells B4:M4 I have the 12 months of the year (May 18 - Apr 19) for Budget data. Then in Cells A7 all the way down to A100 i have...

Hello, I have a spreadsheet with work whereby they want predicted sales figures for each month. The way the spreadsheet is setup at the moment is that we have tabs for each business unit with a list of items each having a column for date and sales figure. What I want to do is have a seperate...

I need to pull together a table figures with the following criteria. Please see the snippet below: https://imgur.com/a/u9mW57l

Hi please have a look at the screen short of the following chart. What I need is to make labels in round figures so that it may not show up messy and overlapping each other. Any suggestion would be appreciated. Thanks EDIT : Rounding the cell ( column) does not have any effect on...

I have a list of amount but it contained spaces before and after figures how can I get only numerical value. like 100,000 78,900 23,000

HI, Please help me write a formula to sort the 10 lowest scores out of the last 20 games and either mark them or copy in the next col. I can add and average the result. The real and complete way to calculate HDCP is 5 or 6 games Lowest 1 7 or 8 games Lowest 2 9 or 10 Lowest 3 11 or 12 Lowest 4...

Hi all, I extracted a large amount of data figures. I noticed that the minus sign is facing the wrong way, and thus Excel is picking it up as a text instead of a number figure. For example, 48-. The correct way I want it to read is -48. What's the best way to reverse the minus sign? I'm...

Is there a way to modify the build in excel function so that when I calculate financial year figures, it will not start from January. For an example: Q1: March- May Q2: June- August Q3: September- November Q4: December- February. Looking forward to receive the response from the members...

Help please... So this seems a bit strange. But then again it may be something some of you may have encountered before. I have a spreadsheet, only 2mb. When i enter figures manually it updates a couple of graphs (no biggie- my laptop can handle this and then some) but it keeps...

hi im using the following within a workbook =VBAProject.Module3.SumByColor(F152,J3:J95) it keeps returning zero.... I have figures in col J3 thru J95 any help will be appreciated... thank you

Hi, I would like to convert the decimal which is equal or higher than .70 to .99 For eg. 12.75 changes to 12.99 10.82 changes to 10.99 else all the other figures remains unchanged 10.39 does not change 19.69 does not change Thanks in advance Hiten

Good evening, Does anyone know how I can line up 3 sets of figures used in a CONCATENATE function please? My formula is: =CONCATENATE("01 = (M) ",TEXT('Main Table'!E8,"0")," - (B) ",TEXT('Bonus Table'!E8,"0")," - (Both) ",TEXT('Main & Bonus Table'!E8,"0")) It produces this for example: 01 =...

I have a 2-page worksheet Excel spreadsheet that keeps track of funds billed for different employees. The spreadsheet was started in Jan 2016 and was supposed to cover a year. My job was to add the total amount of hours worked and based on the employees’ hourly rate, it would list the amount...