# Activity Stream

• Yesterday, 08:48 PM
If I understood you well then For the first appearance (see QID 100298 Rows 2, 18, 23) 10.0.0.1 - 100298 - Server001 - FALSE (Row2) For the...
8 replies | 151 view(s)
• Yesterday, 08:26 PM
Hi experts Need your help to calculate completion time for request. Shift timings : 17:00 to 2:30 For 1 task 3 stages time consumption...
0 replies | 26 view(s)
• Yesterday, 06:45 PM
p45cal... I opted to go with an Access Query to summarize my counts and create an ODBC into excel out of Access, something i should have...
3 replies | 71 view(s)
• Yesterday, 06:02 PM
Hi Ed, Why not just add another column to your Pivot called "Gross Profit" based on conditional logic. Basically if you have Revenue or COGS,...
2 replies | 71 view(s)
• Yesterday, 03:10 PM
=TEXT(TODAY()-MOD(TODAY()-2,7),"dd/mm/yyy") & "-" & TEXT(TODAY()-MOD(TODAY()-2,7)+4,"dd/mm/yyy") or if the date is in cell A2:...
2 replies | 41 view(s)
• Yesterday, 02:50 PM
You can use an IF() statement in Data Validation to choose which list to show, e.g. ...
1 replies | 33 view(s)
• Yesterday, 02:04 PM
Is the number in the parentheses essentially the number you want to extract? If so, try: =MID(A13,FIND("(",A13)+1,1)+0
1 replies | 26 view(s)
• Yesterday, 01:56 PM
Try array formula: =INDEX(\$D\$4:\$D\$29,MATCH(1,(LEFT(\$D\$4:\$D\$29,10)+0<=\$D\$1)*(RIGHT(\$D\$4:\$D\$29,10)+0>=\$D\$1),0)) confirmed with CTRL+SHIFT+ENTER...
2 replies | 41 view(s)
• Yesterday, 01:40 PM
Try this: In AH2 to count billable hours: =SUM(IF(ISNUMBER(LEFT(\$A2:\$AG2,1)+0),LEFT(\$A2:\$AG2,FIND(" ",\$A2:\$AG2))+0),0) Confirmed with...
1 replies | 34 view(s)
• Yesterday, 01:32 PM
Please post a sample sheet - Thx
1 replies | 53 view(s)
• Yesterday, 12:30 PM
Marcel, Good suggestion and one I'm familiar with, but the fingers sometimes don't do what the brain tells them to. As it happens I've lived with...
2 replies | 37 view(s)
• Yesterday, 12:07 PM
p45cal replied to a thread MIN IF Function? in Formulas
When I do a normal MIN formula and there are blank cells among the range they are ignored. So I would guess there is something in the cells which...
2 replies | 63 view(s)
• Yesterday, 11:54 AM
Possibly a case-(in)sensitive issue? If you have a table or query e.g. DEPOTOVERVIEW, then Power Query accepts DepotOverview as a different query...
2 replies | 37 view(s)
• Yesterday, 11:53 AM
Hi All, Im trying to return the dates based on the current date. In the spreadsheet (attached) i have months followed by the date ranges that fall...
2 replies | 41 view(s)
• Yesterday, 11:22 AM
I've got a workbook with a number of queries and tables that I have been very careful to name in a consistent and unambiguous manner. For instance...
2 replies | 37 view(s)
• Yesterday, 10:13 AM
Hi, I have one row of 31 cells in B2:AF2 representing days of the month. Each cell's contents encode the hours within that day that a certain...
1 replies | 34 view(s)
• Yesterday, 09:35 AM
I've attached one option. Just some notes, in Table2 where you have written null, they should be null in your table (Blanks). Table2 duplicates...
1 replies | 95 view(s)
• Yesterday, 04:39 AM
Note the calculated items are Gross Profit and Net Profit
2 replies | 71 view(s)
• Yesterday, 04:05 AM
...In the attached is such a solution (btw, this is really the kind of file you should have uploaded, to save us the bother of recreating it and...
3 replies | 71 view(s)
• Yesterday, 03:23 AM
I have 3 Brand Names with data in 2 columns below. Here is the first data of 'Brand A' .... (Brands B & Brand C are in adjacent columns on the...
1 replies | 53 view(s)
• Yesterday, 03:08 AM
I'm not sure how to do this... In column A, I have several values (copied from an automatic generated report that I can't change) that consist of...
1 replies | 26 view(s)
• Yesterday, 01:21 AM
If you have Excel 2013 or later (I don't) you can do this with a straight pivot table. You would have then Name (VP?) in the row labels area and the...
3 replies | 71 view(s)
• 2017-05-22, 10:51 PM
I would really appreciate your help with a timesheet. I followed this article to limit the choices in a drop-down list, so that it only shows items...
1 replies | 33 view(s)
• 2017-05-22, 10:27 PM
Hello world, I'm looking for a VBA solution that will count unique values in two columns from one worksheet (worksheet "Metric") that is based...
3 replies | 71 view(s)
• 2017-05-22, 10:00 PM
Hercules1946 replied to a thread MIN IF Function? in Formulas
Have you tried the SMALL() function? This includes a number parameter (from 1 to n). It returns the 1st (smallest) to the nth smallest value from a...
2 replies | 63 view(s)
• 2017-05-22, 09:44 PM
If the solution offered by Navic doesn't suit you, then as he has said, can you post some sample data that illustrates your expected results, in...
4 replies | 105 view(s)
• 2017-05-22, 09:06 PM
Beddy Boy replied to a thread Combining IF, AND OR in Formulas
Yes!!! Thank you so much!!
2 replies | 77 view(s)
More Activity