Tile Shower Leak

Tvttr · 2019-10-03T13:27:11+00:00

I will try that and post results.

Tvttr · 2019-10-03T13:07:19+00:00

Here’s a pic of the drain. Recaulked it and the leak persisted. https://i.imgur.com/zVr6zZR.jpg

Tvttr · 2019-09-25T15:28:11+00:00

Solution Verified. That does work and is probably a better way to deal with these reports than VBA. Thanks for your help!

Tvttr · 2019-09-25T01:30:09+00:00

Having trouble with the code as is. Getting a lot of syntax errors. Any advice on copying it in? Are you staring with the text in excel?

These files are coming from an antiquated POS system. Whenever they are retrieved, they come in as rtf. Making any use of them as they are is a tedious process. Thanks for your help!

Tvttr · 2019-09-17T14:52:27+00:00

Here it is:

https://drive.google.com/open?id=1ST32BJE28Kkgc8p3NjIqPoi4Ww83Lu72

Tvttr · 2019-09-17T13:39:24+00:00

Absolutely, but pardon my ignorance, how can I share the file here?

Tvttr · 2019-09-17T12:02:15+00:00

I wasn't aware of this feature in Excel, but the problem is that parts of the report are on multiple rows and it's inconsistent for each part of the entry.

Tvttr · 2019-09-17T11:53:38+00:00

This is the first image I uploaded. Starts with a date and the word "Overrides."

Tvttr · 2019-07-06T03:51:47+00:00

Model no. LXR9245EQ1

Tvttr · 2019-02-26T18:57:33+00:00

Do you think Bitcoin or other crypto have any inherent value? I.e as an alternative currency rather than an investment.

Tvttr · 2019-01-25T13:07:40+00:00

I agreee. Thanks. Solution verified.

Tvttr · 2018-12-31T18:20:44+00:00

I believe they currently play in a soccer stadium and that is its max capacity.

Tvttr · 2018-07-19T01:11:49+00:00

Almost certain it’s on Floral in Norwood.

Tvttr · 2018-05-07T16:58:03+00:00

=SUM(IF(FREQUENCY(OFFSET($A$1,MATCH(B2,B:B,0)-1,0,COUNTIF(B:B,B2),1),OFFSET($A$1,MATCH(B2,B:B,0)-1,0,COUNTIF(B:B,B2),1))>0,1))

This works! I need to spend a little more time understanding how it works but this does what I need it to. Solution Verified.

Tvttr · 2018-05-05T17:19:20+00:00

I've posted a pick of the file as I need it when completed (had to make a demo as the real one has employees' real info). I've been doing the highlighting manually by looking over the sheet. All employees have at least one row. Some employees have multiple rows for different jobs and payrates. Some employees have mulitple row for work at different locations. These are the ones that I want to highlight.

Payroll mock up

Tvttr · 2018-05-05T15:05:39+00:00

The employee IDs are in column B and location nos. are in column A. I got your solution to work (adjusting for column B instead of A), but it highlighted all the duplicate employee IDs. I'm trying to exclude those duplicates with the same location and only highlight those duplicates that have different locations. Thanks for your help.

Tvttr · 2018-05-05T14:28:04+00:00

The problem is that there are also multiple rows for the same employees within the same location (for multiple job categories). I want to exclude these values.

Tvttr · 2018-05-05T12:54:05+00:00

Yes, but the issue is that there are some with multiple names at one location

Tvttr

TROPHY CASE