# Activity Stream

Filter by: Last 24 Hours Clear All
• Today, 12:14 PM
p45cal replied to a thread If overide formulae in Formulas
Array-enter (Ctrl+Shift+Enter, not just Enter) and copy down: =INDEX({"Fail";"Risk";"Pass"},MIN(MATCH(T2:U2,{"Fail","Risk","Pass"},0)))
13 replies | 242 view(s)
• Today, 11:14 AM
jonespandrew replied to a thread If overide formulae in Formulas
Sorry I have read you last response wrong Write Fail Risk would be a fail Risk pass would be a Risk Risk Fail would be a fail Pass Risk would...
13 replies | 242 view(s)
• Today, 11:08 AM
Hi, I've created a form that inserts data at first empty row in sheet. I would like to sum colunm F to N ín every created row and put result...
0 replies | 3 view(s)
• Today, 11:00 AM
p45cal replied to a thread If overide formulae in Formulas
Why do I chuffing bother?
13 replies | 242 view(s)
• Today, 10:16 AM
or: Sub M_snb() sn = Sheet1.Cells(1).CurrentRegion ReDim sp(UBound(sn), 8) For j = 1 To UBound(sn) If sn(j, 2) = "" Then ...
2 replies | 121 view(s)
• Today, 10:08 AM
jonespandrew replied to a thread If overide formulae in Formulas
If T and U are pass the Result is Pass If T and U are Fail Result = Fail If T and U are risk = Result Risk If T is Fail and U Is Pass = Result...
13 replies | 242 view(s)
• Today, 09:49 AM
p45cal replied to a thread If overide formulae in Formulas
Could you tell us what the results should be where I have question marks in the picture below, or if they can never be that way, say so. Also, can...
13 replies | 242 view(s)
• Today, 09:47 AM
See this example. Column 'A' must not be empty.
1 replies | 25 view(s)
• Today, 08:53 AM
jonespandrew replied to a thread If overide formulae in Formulas
Thank you. I am trying also to get the following to work If t2 and u2=Risk then display risk, If T2:u2 = Pass display pass, if T2:U2 =Fail...
13 replies | 242 view(s)
• Today, 06:20 AM
AliGW replied to a thread Help with formula in Formulas
Sorry - your file keeps crashing Excel, so I'm not able to take a proper look.
3 replies | 56 view(s)
• Today, 04:22 AM
The only situation I can think of a file being duplicated in the list would be a copy of the file in a sub folder. In that case you can apply a...
2 replies | 26 view(s)
• Today, 02:46 AM
Logit replied to a thread unduplicated list in Formulas
See the instructions on the worksheet. Your project is already established to do the filtering you require. Just a few more steps to see what you...
1 replies | 42 view(s)
• Today, 02:00 AM
Margaret consider sending excel file with fake data so that we can take a look, screen shots are seldom the best way to help solve issues
2 replies | 26 view(s)
• Today, 12:30 AM
Good Afternoon, I am having an issue getting a row to move to a different sheet based on a cells value. If you look at the ALLTRA tab and see column...
1 replies | 25 view(s)
• Yesterday, 10:17 PM
Run the macro blah in the attached, which is just your file with an added macro. Several asumptions made: Things are already in the correct order -...
2 replies | 121 view(s)
• Yesterday, 10:05 PM
snipeshow replied to a thread Help with formula in Formulas
Here it is! Sorry didnt know that was an option
3 replies | 56 view(s)
• Yesterday, 09:51 PM
AliGW replied to a thread Help with formula in Formulas
3 replies | 56 view(s)
• Yesterday, 09:49 PM
BuddyGSD started a thread unduplicated list in Formulas
Hello everyone, I'm currently working on a spreadsheet for the next 5 months where we are going to provide assistances to individuals. I would...
1 replies | 42 view(s)
• Yesterday, 09:01 PM
Hi Ken & Team - This is my first post, ever!! I'm normally pretty resourceful and can figure things out in excel but this time I'm really stuck! ...
2 replies | 26 view(s)
• Yesterday, 08:12 PM
Possible, but I was really hoping for a neater solution - given that the ETL part is already so neat. What bothers me in particular with this...
2 replies | 40 view(s)
• Yesterday, 07:29 PM
snipeshow started a thread Help with formula in Formulas
Hi, I have the following workbook that extracts period revenue information from a search function that matches the journal entry that is typed in...
3 replies | 56 view(s)
• Yesterday, 06:43 PM
Another cross post.
3 replies | 76 view(s)
• Yesterday, 05:55 PM
Ken, that was quick, totally works. Thank you, saved me bloody hours!
2 replies | 42 view(s)
• Yesterday, 05:29 PM
Quick fix... select all the columns that show nulls and do a replace null with 0. After you've done that, then run your SUM across the columns. ...
2 replies | 42 view(s)
• Yesterday, 05:20 PM
Lost me here... if you're pulling queries from the worksheet, why do they need to mess around with M? You can code things up and just send them an...
2 replies | 40 view(s)
• Yesterday, 05:14 PM
Yes, but it's a bit complex. Basically, you suck in the table, then reference that query twice. In the first, you remove all rows, then demote...
3 replies | 76 view(s)
• Yesterday, 05:11 PM