“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

HI, I have just been on here and one of your experts helped me with a formula (Shown in cells I12:I23 (big help). However this only looks at the dates in column B. I need a formula to return the same results but only if the cells in column C are "complete" or "H&S complete". Can something be added to the formula given to me previously, to return results only for these criteria?
Thanks in advance

Solved by I. H. in 14 mins

I am trying to categorise some deliveries by drop 1 or drop 2.
any item (row in excel) to the same postcode on the same day that are larger than 2 hours apart on the last scan need to be shown as a separate delivery (drop 2). I need help creating the "drop that day" column.
many thanks

Solved by B. L. in 30 mins

Hi, I'm trying to write a formula to calculate the sum of the n groups of the products of 3 columns. For example =SUM(PRODUCT(B3:D3),PRODUCT(B4:D4),PRODUCT(B5:D5)) would be a basic answer, but this would be tedious to do if the number of rows were a lot larger. I know I could create another column for the products, then a cell for the sum of these products, but I was just wondering if I could do it without this additional step.

Solved by K. C. in 20 mins

How do I use an Excel function to derive the column’s value for each row based on different rules?

Solved by Z. L. in 17 mins

How do I create a PivotTable based on the highest percentage of "strongly agreed" (5) responses for Q6 or Column L with respect to the total # of "strongly agreed" responses given, filtered by Course No.?

Solved by E. W. in 14 mins

I need to make a pivot table of multiple sheets that represent data about the same thing on different years.
The columns are: Name/Position/Unit/Hours. There can be several rows containing the same combination of Name/Position/Unit, as the same person can have taken the position for several isolated periods within the year.
I need to show sum of hours for each year. As I understand, to show that I need to have the relationship defined, for which I need column in those tables with unique values that I don't have. How can I create the pivot table I need?

Solved by K. D. in 30 mins

I am having difficulty developing the VBA code to lock a timestamp in excel. I would like to have the data input in the "completed by" column, create the timestamp in the "time completed" and then have that column locked so that no one can manually change the time.

Solved by S. H. in 15 mins

i am trying to create a macro or vbo that can look at a large list, see if one line share common with another and input that data in a different column

Solved by C. H. in 30 mins

Sheet 1, Column A is blank. Sheet 1, Column B (B2 through B30450) has random school names. (Example: Breakfast Point School). Row 1 has headers. Sheet 2, Column A (A2 through A58) is filled with four-digit numbers (school numbers). Row 1 also has headers. Sheet 2, Column B is filled with school names (Bay High School, Breakfast Point School, etc.) I want Sheet 1, A2, to look for the correct school number in Sheet 2. How do I proceed?

Solved by E. A. in 20 mins

Anything under column 'C' server name, shown in any value (numeric or alpha) in columns 'E, F, G or H', that coincides with (PRD) from column 'A' should be listed under column ;M' as the number '1'. If nothing is shown then column 'M' is shown as '0'. The same is for server names in column 'C' that are listed under (UAT) in column 'A' shown in columns 'E, F, G or H' that are shown in column 'J' as the number '1'. If nothing is complete show as '0'. Column 'K' should be triggered on any server name with 'SST' and should be triggered be 'INF', 'SQL', TEST', WEB' in column 'L' as a numerical '1'. Basically anything numeric or alpha listed in columns E thru H will be shown as '1' if nothing show as '0' for by the above guidelines.

Solved by E. D. in 19 mins