Search results

How do I determine the result in this instance please? Currently it either returns TRUE or FALSE but I'd like to specify different text, ie. "Ok" or "Not Ok"

Hi, I'm trying to get a formula that looks up the amount of months remaining on a grant and then automatically adds in as many date columns as necessary. For instance, I have uploaded a file which has 8 months remaining, so the month columns that I will need populating are Apr 16 - Nov 16. The...

I have a list of different grants, each grant has a person responsible for it. On a separate sheet I would like to just lookup the persons name, ie. have a sheet per person and for a formula to list out each different grant associated with them. Is there a way of doing this? Oh, and I would need...

Hi, Im getting so confused joining IF's together, does anyone have a more simplified way of writing my formula please? If I can get the formula in column Q right I can sort everything else, basically there are so many variables that need to be included please see below; Column BH-BM gives how...

I have read the thread http://chandoo.org/wp/2010/06/01/date-overlap-formulas/ Which is handy but how can I get the result to tell me by how many days it overlaps by please?

This is probably a stupid question but is there a simpler way of doing loads of IF formulas? Each IF has different criteria and a different result, I was thinking I could do a SUMPRODUCT but that would only return one result that matches all the different criteria wouldnt it? The formulas are in...

Hi All, I was wondering if there was a better way of doing this formula; *Hint* (Its exactly the same formula 4 times) =SUMIFS(APR14.DATA!$O:$O,APR14.DATA!$Z:$Z,$C11,APR14.DATA!$X:$X,'P&L CATS'!$A$1)+SUMIFS(APR14.DATA!$O:$O,APR14.DATA!$Z:$Z,$C11,APR14.DATA!$X:$X,'P&L...

I have the following formula; =SUMPRODUCT(--([Lookupsheet]A:A=A1),--([Lookupsheet]B:B=B1),--([Lookupsheet]C:C=C1),[Lookupsheet]D:D) As there are more than one row that matches this criteria my formula is adding all the instances in "D" together, they're all the same so I just want to return the...

I have just started up on my own in Bookkeeping/Spreadsheet Modelling and have my first client who just wants me to reformat his 4 year cash flow forecast, he's got all the figures he just doesn't like the format that the person that created it did it in, Obviously it depends on his requirements...

I have a Macro that takes a Password Protected workbook and does certain things to it then saves it in another area, I would like to remove both read and modify passwords on the newly saved version, I tried to record the action of me doing Save as - tools - general options and deleting the...

I have one cell that has an EOMONTH formula in, returning the number 3 (for March) I have an offset formula that needs to use this number as the width, but because it is an EOMONTH formula, the Offset returns a #REF!, if I was to hard code the 3, my Offset formula works, how can I get this to...

I have a period of 01/02/13 - 30/03/13 I have another period of 01/02/13 - 05/02/13 I need to know how many days of the first period (01/02/13-30/03/13) appear in the second period (01/02/13-05/02/13) Answer = 5 Please help, this is driving me mad!

My mind is going blank on this, Im sure it must be easy! I have a period ie. 04/01/2013 - 02/02/2013 elsewhere in the spreadsheet I have; WK 1 01/01/13 08/01/13 WK 2 09/01/13 16/01/13 I need a formula that looks at the period and puts a "1" in every week that the period covers, what...

Has anybody else had a problem when clicking Save as to change the file type? I have encountered this problem a few times now using Excel 2010, the first time was a csv file that I made some changes to I then wanted to save as a xlsx but when I clicked the drop down menu to select Excel...

I've got a problem with linked spreadsheets having to be open for my formulas to work, I'm clicking no to "Do you want to update" but it seems that it still needs the source workbook open as its just coming up with #VALUES, I've never had this problem with older versions of Excel is this a known...

Hi, I've gone a bit mad and can't seem to get this SUMIFS to work. Code, Jan, Feb, Mar, Apr, May, Jun 101, 54564, 55, 212, 154, 454, 98 214, 78214, 65, 784, 986, 487, 475 101, 71234, 87, 871, 369, 473, 247 I'm writing my SUMIFS as so; SUMIFS(B2:G4,A:A,"101",B1:G1,"May") To get a a...

I need a formula that says; If A does not equal B, and A does not equal C return the result in D whats the best way of doing this please?

How do you use the <> in a SUMPRODUCT please, I thought I could just replace the = with <> but it's not returning the correct result. Please see example =SUMPRODUCT(--('[LIS New Sales.xlsx]Jan12'!$C:$C="N"),--('[LIS New Sales.xlsx]Jan12'!$O:$O="INTERNET")+--('[LIS New...

I'm trying everything possible to reduce the size of my files as it takes so long to open and crashes other peoples machines when they use it, I have already pasted as values so absolutely no formulas are in here at all, I have deleted all rows and columns to the bottom and right of my work on...

Hi, I have been using the formula you gave me in my post titled "Count unique values if Multiple Criteria are met ?" but unfortunately it is slowing up my workbook too much for other people to use, I have been given the advice to concatenate my 3 criteria which I can see would probably help but...

I have a formula =IFERROR((SUM(IF(('H:BDMLMarketing CISMITarynSDLFiles to open[SDL Sales.xlsb]Apr12'!$N$12:$N$9236="ADON")*('H:BDMLMarketing CISMITarynSDLFiles to open[SDL Sales.xlsb]Apr12'!$AH$12:$AH$9236="Web")*('H:BDMLMarketing CISMITarynSDLFiles to open[SDL...

I was trying to make an Excel file smaller and found online the download WINZIP, I put my file into WINZIP and then moved it back into the original folder but half way through doing this I realised WINZIP hadnt actually made it any smaller therefore I just cancelled the save into the original...

Im wondering if there is anyway I can have more than one data validation list assigned to one cell based on whether an IF formula is true or false? eg. COL A, COL B, LIS, (Data Validation dropdown list) SDL, (Data Validation dropdown list) AQ, (Data Validation dropdown list) There will be...

I have a template that our Marketing Department records invoices on, in order to have them use the correct source codes I also had data validation rules mixed with VLOOKUP's pulling through the correct codes, unfortunately the problem occurs when the same source is used for different entities...

I can't seem to work out whats going wrong with a simple COUNTIFS, I've even just broken it down to a COUNTIF and thats not even working, its returning a figure over 1000000 different to what it should be, the only thing that's a little bit different about it is that all critera are looking up...