-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
based on
-
P
IFERROR formula help
Hi All I have a column (in sheet called worksheet column E - starting in row 2) with all names, including duplicates. I wish to make a list in a seperate sheet in column A with only the unique values (each name once in this list - starting in row 6). This list must also look at the value in...- Pottie8
- Thread
- Replies: 3
- Forum: Excel Questions
-
P
Hide cells if month different from previous cell
Hi. I have searched but didn't find anything similar. Found some posts about dates but nothing like what I am searching for. My question: We work with a worksheet to register quality issues occurred during a certain month. The sheet is printed out a few days before the start of the new month...- Pitbull_Raven
- Thread
- Replies: 6
- Forum: Excel Questions
-
B
Conditional Format based upon another cell
Hi, I need some help. How do I place a conditional format for one cell that is based upon the value of another cell. i.e. - A1 turns red if A2 is greater than 2. Thanks, Chris.- bergevpi
- Thread
- Replies: 8
- Forum: Excel Questions
-
K
Subtotaling based on date in a column
I am trying to create a subtotal in Column L for the values in Column K that all have the same date in Column A. All of the Dates in Column A are in chronological order. No dates are out of order. Example A1 = 11/2/2008 : K1 = 22.00 A2 = 11/2/2008 : K2 = 25.00 A3 = 11/4/2008 : K3 = 12.50 A4 =...- kylewent
- Thread
- Replies: 3
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Help with summation of different rows in 1 column
- Started by bassemjohn1
- Replies: 30
[B]Hello guys, [/B] I am new here and am in need of your help,I have a report that is really taking a huge time and all I need is a [B]way to sum... -
Excel VBA Code to Compare Rows in Two Different Sheets and Highlight Only the Cells that are different/unique
- Started by Walkerwood9
- Replies: 25
I have a workbook that has two sheets in it and I want to compare these sheets (Test1 and Test 2) and highlight only the individual cells that are... -
COUNTIFS function help please
- Started by andrewmurray86
- Replies: 25
Hi all, This is my first post here: I'm attempting to identify the smallest number within a column. I have a series of sheets with a column... -
Move row automatically to the bottom of the sheet when cell changes
- Started by CindyLou
- Replies: 23
I have a column of "Open" and "Closed" items. When the cell is changed to "Closed," I'm trying to get the whole row to go to the bottom of the... -
Change date format on import
- Started by namloop
- Replies: 37
Good morning I am importing some data and I am having two different issues in col. B. In rows 3 this data says Nov-9 (the 9th of November) when I... -
Problem with macro
- Started by Jeeremy7
- Replies: 20
Hello, I have a macro running but i think some informations are in double so the macro doesn't work.. If somoene could help it would be really...