Search results

This is great - very helpful and it works as expected - thanks so much!

Hello! I have a worksheet I'm trying to reset back to zeros with a recorded macro - I don't write VBA code, so not sure this is even possible. I have been able to reset the worksheet in all cells except for the ones with dropdowns, which I'm trying to get back to "Select %" (cells B4 and E13)...

I have a workbook that logs attendance for classes, separated out into yearly worksheets. I am trying to find a way to automate it and can't figure it out. What I need a function to do is when a trainee name is typed into a cell in column E on worksheet 2018, to search all of the rows above it...

I have a column with over 1200 rows of email address in this format: Smith, Ross <ross.smith@abcd.com> In each of the 1200+ rows, I am needing to remove everything but what is inside of the brackets, so I would want that cell to say: ross.smith@abcd.com What is the best way to remove the...

Works great - thank you so much again!

These are great! Thank you so much for your help! Now, if I need to do the entire A column, should I change the A in the equation to an A:A? Thanks

Hmmm - I pasted this into the data validation and it's restricting my entries, even when they follow the correct format. I pasted this: OR(MID(A2,9,1)="W",MID(A2,9,1)="H")*(LEN(A2)<16)+(MID(A2,9,1)="M")*(LEN(A2)=9))*(LEN(A2)=LEN(SUBSTITUTE(A2," ","")))*(ISNUMBER(LEFT(A2,8)+0)) And I tried...

Is this a function to type into the custom form in data validation?

Yes, I do - the 9th character options would either be M, W, or H... there shouldn't be an F in the 9th character spot. Sorry for the confusion.

I am trying to use Data Validation to limit what goes into a cell. I have a specific format that must be followed and I've tried creating a function using ISNUMBER, AND, SEARCH, IF, and SUMPRODUCT and am just lost with no success. I'm not even sure it's possible, so any help would be much...

I have a worksheet that I'm trying to get two IF functions developed based on criteria in other columns. I have been playing around with compounding the IF function with the Frequency and Sumproduct functions and keep coming up wrong and was looking to see if I could get some additional help...

That works - thanks so much!

Ok, I think I oversimplified the example worksheet and just made it more confusing. Let me add another one and see if I can explain it a little better. In column A, I have a list of ID's. There will be multiple duplicate ID's and then a new ID. At each change in ID, I need a new grand sum in...

Right - that's where I would want the sum totals to go from column E, so the cells that I would need to enter in the function? So add up numbers from E with that total showing in F as a running total, assuming there's no duplicates (like row 10 in the attachment.)

That link addresses the unique value part, but only references 1 range that I can see. I need to compare two different columns and remove the duplicates from each of those two ranges.

Sorry, I guess it didn't save. Adding it now and I'll check out your link - thank you!

I have a worksheet that consists of 6 columns. I am wanting to add up numbers from column E into column F, but only if it's not a duplicate line, as seen in column B. In the example I am attaching, lines 1 and 10 are duplicates, so that should not be included in the sum value. Thanks for any help!

Never mind - I found the shortcut!

I know there is a way to select a cell that contains a function and show which cells are contributing to that function, but I can't remember how. I don't want to use the ~ symbol to open up the function, but actually show the arrows that contribute to the function. Any guidance?

I have a sheet with around 30 columns and 15k rows. Some of the rows have a cell colored, some rows do not. How do I filter the sheet to only shows rows that have at least one colored cell (some rows have multiple colored cells). I have attached a mini example for visual purposes. Thanks in advance.

Thank you! I was still hoping for a running total time subtracted from the target times on the 2nd worksheet - not just the total outage times like what you have on the PivotTable. I need those hours to be subtracted from the corresponding target times on the other worksheet and keep a running...

Not really - I need the hours in column D from the YTDTotal worksheet subtracted from the minutes in column K in the Targets worksheet by category that keep a running total as I add more outages.

I have a workbook that has 2 worksheets. The first is YTDTotal and on that worksheet, I track system outages. These outages are tracked by Affected CI (which is column C) and column D gives me the total Impacted Business Hours Duration in hours (which is calculated by subtracting column E from...

I know it has to do with rows 38-43 because once I can (eventually - very long process) get them deleted, the whole program starts responding normally again. I didn't know if it might have something to do with the $ and / being used - maybe Excel is trying to perform a function that isn't...

Here is the file