stay

How to make rows that contain/are connecting to rows under them? So that when sorting the rows the items under certain number wont mix with other numbers? So if I have list of projects and I arrange them by number in A row , how to bind the list items to a number? or additionally how to add A...

Hello All, I have a work spreadsheet. I am searching for the minimum date in a column, but if there are no dates entered I want it to stay blank. So formula for min is =min(L6:L55). But when there are no dates entered it defaults to 1/00/00 when I want it to just stay blank. any help would be...

Hi Folks, When I type 3-5 in a cell it automatically corrects to 3-May. I do not want this but want it to stay as 3-5 What do I do ? Thanks AFD

Hi, Using condition formatting, I'd like a cell to go green if '1' or above is entered, go red if '0' is entered, and stay white if the cell is empty. Please help. Thanks!

This works great until A1:A3 has a zero involved, then it returns all zero's. Pretty sure it has to do with *(multiplication) but would like to stay with sumproduct if possible. 1] A5 =SMALL(A1:F3,1) 2] In B5, formula copied across right until blank ...

is it possible to delete value without formula? i mean if cells contain formulas..i want them to stay as default..if anyone delete the cell. formula must stay as default is it possible with macro or any tips?

Hi- Is there anyway to calculate slope and intercept when data is filtered? I tried using named ranges and the two variables stay the same regardless of the filtering. I would like them to update. Thanks!!!!

Hi everyone, Need your advise to solve my problem as below example data; ARR = Arrival DEP = Departure A B C D 1 ARR DEP length of stay (night) Guest Name 2 26nov 2dec 6 Rihanna 3 30nov 5dec 5...

If a cell says"Y" I want the next cell to have a numerical value, if it says "N" I want it to say "Nil" If it is blank then I want it to stay blank. The first two bits I can do, I just can't do the last.

Hi All, I have a workbook with several array formulas down a column. They each pull data from tables in a separate sheet sequentially, whereby each array formula pulls out the next available numerical cell value with multiple criteria. On one of the sheets the 7th array formula down always...

how would I get this formula to work using the indirect function on cell S8? I want that cell to stay the same when I insert a new column =+IF($S8<>0,(IF($S8=0,100%,$GA8/ABS($S8))),0) Thanks

I'm trying to record a macro for rolling forward our financial statements. In doing so, I have to copy column D then insert copied cells. I then hide column P and in column FY it has a calculation for column D and column O. when recording the macro I highlighted all the cells and did a...