figures

Hi, I hope someone can help. I am trying to create a formula to yield a set result based on the figure of once cell, and I can't seem to get anywhere with this. Here is what the figures are: (Column A) (Column B) Products sold Amount paid <15 £0 15-19...

Hi all, I have been learning from this forum for years, and now it is time for my first post. Thanks in advance for your help and for all these years of teaching :) I need to convert yearly figures to months, following a given trend, and then automate the workbook so it can be done as...

Hi all and i appreciate taking the time just read this, i have a fairly simple understanding of excel but have taken it upon myself to set a new detailed family budget and run sheet, what i'm after is some help working out what formula/coding i need. what i'm trying to do is sheet 1 (bills) has...

Hi all, wonder if anyone can help me with this one please. I have a formula, listed in full below, but the part I am trying to amend is in blue: =IF(A5="","",IFERROR(INDEX('GMS Throughput'!$B$2:$Y$350,MATCH($A5,'GMS Throughput'!$A$2:$A$350,0),MATCH(SUBSTITUTE($BM5,"Report","Throughput"),'GMS...

Hi all! As usual, under the gun and spending time searching for this solution, but not finding it so I'm back to bothering y'all! I'm trying to figure out how to do the following: a) Total one column of sales figures. (H7:H60) b) Based on two different criteria: ----The first is based...

I'm going round in circles.....I have created an Excel file with a table with figures then on the same sheet I have converted it into a bar chart. I now want to create a word document. So I copy and paste the table with figures no problem but when I try to do the same with the bar chart it...

Hi guys Struggling with what I think should be fairly easy to resolve... Advices please! Data: <tbody> A B C D E F 1 DATES NAMES £ FIGURES 01/11/16 2 </tbody> The formula I want in F1: > looks for all dates in Column A from E1 + 12m (so, 01/11/16 to 01/11/17) > looks for a...

This is probably impossible, but I'll ask it anyway. Is there a way to open, say, the 10 most recently modified spreadsheets in a particular folder? At my place of work, a new spreadsheet appears every 15 minutes in a specific folder with figures etc related to my job. In a super ideal world...

Morning all Data, as follows: A - list of dates B - list of names C&D - list of £ amounts E - list of figures between 0 & 4 F - list of dates: 01/11/16, 01/12/16, 01/01/17 etc I need a formula that: > pulls out all dates from A within a month of the date in F > sorts by the names in B > sorts...

So I have created a pretty neat spreadsheet for payout for different events for a yearly golf tournament. It looks at the different events, par3, par5's, birdies....figures out where they placed in their flight, figures out how much they get based on how many in their flight got in and then...

I have a column of negative times which I wish to sum and average. formula that brings these figures is IF(S738="Remove/Post",O738-T738,IFERROR(IF((Q738+"00:00:01")-O738<0,"-"&TEXT(ABS((Q738+"00:00:01")-O738),"h:mm"),(Q738+"00:00:01")-O738),"")) Now, as you see I'm putting the "-" in and text...

I'm trying to set up a query that references a table of attachments. I have many fields that I want to associate with images or CAD files. I've set up a table that includes a list of fields from various tables that I can search with a query to get more information. (I'm open to other suggestions...

I need to learn how to create a database on Excel as we have given a diagnostic test to our students, and I need to create a database that allows me to create various sorts of table and figures. I noticed, however, that if I enter a, b, c, d as their the students' answers to multiple choice...