-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. 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
- apple based on duplicates iferror pear
- 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
- based on date different month hide cells
- 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
- based on cell conditional format
- 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
- based on date column subtotaling
- Replies: 3
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
