-
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.
ac4
-
T
Countifs formula
I have the following formula in cell AC4 =COUNTIFS(Rates!G8:G455,">1000",Rates!U8:U455,AB4) The formula works. However when I changed formula to =COUNTIFS(Rates!G8:G455,">1000",Rates!U8:U455,>=AB4) I get an error message. I tried this...- Tennisguuy
- Thread
- ac4 cell equal formula number
- Replies: 3
- Forum: Excel Questions
-
Y
Editing a formula
Hello, I have this formula in my project in cell AC4, "=IF(D4>0;AC3-Y4;0)" . AC3 is a date cell equals year 2014. if in Cell U3 i have date 2015, i want to get 0 in cell AC4. Thanks in advance for any help. Best regards.- YOUNAN
- Thread
- ac4 advance cell date formula
- Replies: 14
- Forum: Excel Questions
-
E
Auto-populate sequence
Hi, Is there a way to automate the process below? Auto-populate a column with a sequence number using another column as a lookup. For example, in the data shown below, auto-populate column C (SH#) with a numeric value in a sequence using the contents in column B (PSharing). And if the values...- eddiegb1
- Thread
- aa4 aa5 ab5 ac4 column
- Replies: 5
- Forum: Excel Questions
-
N
Display date above the left-most cell that contains a certain letter/number combination?
This is an example of a formula I would like to house in the AC4 cell that will display the date above the left-most cell that contains: Any number from 0-999 Any number/”C” combination such as: 0-9C 10-99C 100-999C I would like the formula to exclude the “CO” code and any other character...- ntech
- Thread
- ac4 cell combination date display
- Replies: 14
- Forum: Excel Questions
