please help me

This would be helpful. Thanks in advance!!

Is there a way to highlight all duplicate cells while ignoring empty cells? I have my data in s12:y31 THANKS in advance!

I am trying to highlight column B based off of values in column A. If A has the word parts in it, then I want B to change. I Googled it and seen several examples, I just can't find a way that works for me...

I have an if formula that has a variable. I'd like to search for a keyword (diesel) and if it is found, return a string. I thought about IF(F23="*diesel",S$33 but that didn't work. Any ideas?

The first 4 parts work, but none of the rest. Any ideas why? =IF(ISBLANK(A19),"",IF(A19="tow","Towing",IF(A19="etow","Emergency roadside towing",IF(A19="itow","In house towing",IF(A19="inspect","Inspect to determine necessary repairs",IF(A19=”dot”,"DOT re-inspection fee",IF(A19=”scene”,"Clean...

First Name Last name Suffix Complete name Last, First Phone DOB Hire Term SSN Tenure Phone SSN Age john doe jr John Doe Jr Doe, John 8158675309 5/21/73 11/28/2017 123-45-6789 2 years, 11 months, 5 days (815) 867 - 5309 6789 47 If I enter a date in the term column (j2) is there a way to...

i have a excell sheet Data base which need to be sorted like 1. Add two colums before C 2. Remove these columns H,I J,O to V and X,Y, Z and finaly AB,AC AD and AF 3. the DeleteRows if coume G has valued as "Documentation Validated - Awaiting Funds" 4. finally from column N DeleteRowsAfter...

Madam Sir Boss Good Afternoon and Good Evening or Good Morning I would like to ask a help for excel my problem are if i type a number excel column a1 like example if i type a 1 the out-come or out put will be Box-1 or Box-001 is this posible in excel? if it is how?

I have a spreadsheet that has my driver's names (and other data) and another spreadsheet that I use that data for. When a driver is removed from the driver data spreadsheet, I receive an error on the other sheet... The formula works well until I remove a driver. The formula I use: ='[N&I...

after researching..i couldnt really come up with much results which is why im posting here. 1] is it possible to make out combinations with the given data? 2] also, i have to make sure that when it is combined, the total =10 not more or less Here's the data: <tbody> a b c d e f g h i o p q r...

My formula =LARGE(AE$2:AE$999999,AK2) works great BUT if it locates a duplicate value, it reports the first of the two twice. Is there a way to correct this? Thanks in advance!

Hi all, I'm very new to VBA and need help copying data from one sheet into another sheet based on a specific date. I am in charge of invoicing business for the hours employees have worked. This is a large business with a large number of employees and copying and pasting manually takes a lot of...

Below code trims the value for the selected cells.It Works fine But when i an trying this for 10Lacs Item it is showing "Run Time Error '1004':Application-defined or object defined error" please help me... Public Sub Callback13(control As IRibbonControl) ''propercase For Each cell In Selection...

1. I have a text "test" in cell "A1" in "sheet1" which is hyperlink'd to a hidden sheet "sheet2". I have sheet code sub in "sheet1" "worksheet_followhyperlink" which allows me to click the text "test" to unhide & select "sheet2". 2. I have created a button on top of hyperlink'd text "test" in...

Hi everyone, I have a question that I'm hoping someone can help me with. I know it may sound simple, but here it is: I have to create an auto loan model for a new business, and each year I have to assume the business picks up new customers who sign on to auto loans. For example, from...

Hi,I am having trouble with excel 2013. I am currently working on a workbook for my school newspaper's business team. I have a revenues and expenses table, the expenses table links to a fundraising goal table so that everytime we spend money on an item, if that item is located on the goal table...