duplicate alert

Hi all! I'm racking my brain trying to figure out how to create what I thought was a simple spreadsheet for our company's contracted tow roster. We have 4 towing companies. Each time a vehicle is towed, the next company on the roster gets to tow the next vehicle and so on until all 4 have...

Hi there, Old thread I know, I'm having a little bit of trouble getting something to work. I'm also a bit of a novice, I'll admit. I'm trying to Populate a table, this I've succeeded in. Now however I need the information in a specific cell to be read and held against a portion of my table to...

I am sorting data from a large table (called Games) for the top ten fastest running times, I will be continually adding new data to the table and the top ten times may change moving forward. I have attached a picture to be used as a visual, which also includes the function I am using. The...

<tbody> C1-a C1-b C1 prevent C2 C2-a prevent </tbody> Hi, I found many posts that have solution to prevent entering duplicate values in a column's cell. I am trying to solve the same problem which has little different flavor. In above table I want to stop users if they try...

Hello Everyone, Hope you are fine. I have a spreadsheet and there is a column contain duplicate value. Pls find below for example <tbody> A B C D 1 1200 2 1500 3 1200 4 1700 5 1200 </tbody> I need a formula in B1 where result should be like below: <tbody>...

hi, I will like to do an advanced filter so that I can spot duplicate.First, let me go through my sheet first. I creating a shet for the user to make a booking for their the slot. 1. First user input the start time of the appointment at V3 2. the total hours of the booking at V5...

I created a VBA code that will prevent users from selecting duplicate data from a drop down list in column C of my excel spreadsheet, however I want users to be able to select "Other" in multiple fields without receiving an error. Here is the code that I have written but need to show how to...

<colgroup><col><col><col><col><col><col></colgroup><tbody> Hello, I had an excel test that I didn't do particularly well on, but this one question had me stumped. I need an equation that takes the name in this list and out puts the agent name in 'first.initial' or...

Hi, I need to write a macro sub for preventing of entering duplicates in column M in excel. Ex: I enter "A - 100" in cell M5 If I enter "A - 100" in cell M7 I want to show me an error message that is duplicate. I tried Data validation but the formula does not work, so I want to use a macro.

Hi Guys, I have a challenge which I am struggling with. I need to highlight duplicates in rages across multiple sheets in a workbook. There are 26 ranges which contain text values and the ranges are the same from sheets 1 to 10. Ranges are: D5:R5 D13:R13 D21:R21 D29:R29 D37:R37 D45:R45...

Hoping you can help with this one. In column AL there will be continuous data added into the next available cell. As each new cell gets data inputted, I need a formula that can flag the most recent cell entry in that column AL when it is a duplicate of an already existing entry by color...