# Activity Stream

• Today, 12:58 AM
ohhaykfrankk started a thread 2010 index match in Formulas
My table is as such: Column B: Names Column E: Remainder Column K: Criteria is True or False. I need a formula that searches for TRUE in column...
0 replies | 4 view(s)
• Yesterday, 11:48 PM
Hello I don't think that COUNTIF itself will work, but it can be done using SUMPRODUCT, if that helps. :) See my attachment.
1 replies | 41 view(s)
• Yesterday, 11:00 PM
coachclint replied to a thread If statements in Formulas
thank you - the two formulas you provided are outside of my scope unless they are explained teacher to student :) as a caveat to this - how do you...
7 replies | 69 view(s)
• Yesterday, 09:33 PM
NBVC replied to a thread If statements in Formulas
I was also going to suggest: =IF(G14="ns",-10,IF(ISBLANK(G14),0,LOOKUP(G15-\$B14,{-9.99999E+307,4,6,8},{5,2,1,-5}))) but I went the easier...
7 replies | 69 view(s)
• Yesterday, 09:19 PM
p45cal replied to a thread If statements in Formulas
What are all those AND(...)s doing in there?; they seem at first sight to be superfluous. You could also try the likes of:...
7 replies | 69 view(s)
• Yesterday, 06:18 PM
coachclint replied to a thread If statements in Formulas
well thank you - i had it at the back end - i must have been missing something to throw the error
7 replies | 69 view(s)
• Yesterday, 06:07 PM
NBVC replied to a thread If statements in Formulas
Try: =IF(G14="ns",-10,IF(ISBLANK(G14),0,IF(AND((G14-\$B14)<=3),5,IF(AND((G14-\$B14)<=5),2,IF(AND((G14-\$B14)<=7),1,IF(AND((G14-\$B14)>7),-5))))))
7 replies | 69 view(s)
• Yesterday, 05:51 PM
coachclint replied to a thread If statements in Formulas
7 replies | 69 view(s)
• Yesterday, 05:48 PM
NBVC replied to a thread If statements in Formulas
i don't see a formula in H1.
7 replies | 69 view(s)
• Yesterday, 05:38 PM
coachclint started a thread If statements in Formulas
Hi, I am having some trouble with a NESTED IF statement and could sure use the help. I am also sure that there would be another way to achieve the...
7 replies | 69 view(s)
• Yesterday, 05:10 PM
Fab! That's the Ticket - woop! woop! Truth be told I would never have figured that myself so huge thx!
5 replies | 36 view(s)
• Yesterday, 05:04 PM
That's brilliant, thanks very much! Saves me a lot of hassle and time. :)
2 replies | 29 view(s)
• Yesterday, 04:54 PM
A shared 2013 workbook saved in Win7E displays differently on Win10. - Filters move to the next row from originally filtered row - Automatically...
0 replies | 19 view(s)
• Yesterday, 04:14 PM
Change given conditional format rule formula to: =AND(I1<>"X",B1<TODAY()-3)
3 replies | 57 view(s)
• Yesterday, 04:13 PM
If you enter a date in a cell, say Mar 3, 2017, then select the cell then right click and go to Format Cells. In the number tab, choose Custom and...
2 replies | 29 view(s)
• Yesterday, 04:11 PM
Hello Govind, Thank you for your quick reply. So my column A has all the dates of the original inquiry. Once the inquiry has been quoted we...
3 replies | 57 view(s)
• Yesterday, 04:07 PM
Does this work? =COUNTIFS(\$O\$2:\$Y\$34,"*"&C1&"*")-COUNTIFS(\$O\$2:\$Y\$34,C1) assuming you have "Green Banana" in C1
5 replies | 36 view(s)
• Yesterday, 03:58 PM
I have a table that contains sales detail transaction lines. I need to build a list of the current assigned salesperson for each account. To do...
0 replies | 19 view(s)
• Yesterday, 03:52 PM
Thank you for the help - really appreciated. Tried both and I am obviously missing something as the results are not right so here's what I have ...
5 replies | 36 view(s)
• Yesterday, 03:42 PM
I need to fill a section of dates in the following format: due 06/03 due 13/03 due 20/03 due 27/03 due 03/04 due 10/04
2 replies | 29 view(s)
• Yesterday, 03:20 PM
Try: =COUNTIFS(\$A\$2:\$A\$7,"*banana*",\$A\$2:\$A\$7,"* *") this will only count if the word banana is found plus if there is at least one space...
5 replies | 36 view(s)
• Yesterday, 03:11 PM
Brinley, I've created this and then put somewhere else the formula =COUNTIF(A1:A5,"apples") and I get the answer 2, if i use the formula...
5 replies | 36 view(s)
• Yesterday, 02:44 PM
Hi I am stuck on trying to use excel to perform a query and I am not entirely sure it even possible but figured I would throw it out to see if a...
5 replies | 36 view(s)
• Yesterday, 02:22 PM
NBVC replied to a thread Formate rule in Formulas
Use conditional formatting. Select the range you want to affect. Go to Home > Conditional Formatting > New Rule Select "format only cells that...
1 replies | 40 view(s)
• Yesterday, 01:54 PM
Hi, We are receiving this error 400 at the startup of a sheet. I am new at this so would like some help on how to troubleshoot these things. Is...
0 replies | 28 view(s)
• Yesterday, 01:34 PM
jonespandrew started a thread Formate rule in Formulas
Hi their I have column that contains a list of due dates I want the due date to highlight a specific colour of today's date is greater than the...
1 replies | 40 view(s)
• Yesterday, 08:06 AM
Hi Mr Patel, You can use conditional formatting as mentioned below. 1. Select entire column "A" and then Go to conditional formatting, New...
3 replies | 57 view(s)
• Yesterday, 12:11 AM
Just a slight change needed (to B1) and it works. Thanks again for your help. =IF(SUMPRODUCT(--ISNUMBER(FIND("/"&A1:A18&"/","/"&SUBSTITUTE(B1,",...
4 replies | 117 view(s)
• Yesterday, 12:05 AM
Hello, I have a spreadsheet which employee's log in dates and inquiries as they get them (date goes in cell A1). The next step is they check off a...
3 replies | 57 view(s)
• 2017-02-22, 10:52 PM
Hercules1946 replied to a thread WEEK Commencing in Formulas
Yes, you do! :) Already answered in Post #4. I started the week on Sunday because in your first post you said you wanted to show W/C 12/02/17,...
5 replies | 114 view(s)
More Activity