| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to edit formula without changing formula of each cell
Hello,
My problem is: I use a very large formula:=SUMPRODUCT(--(TEXT(F13:F59,"yyyymmm")="2007Jan"),J13:J59). and the formula is used in more than 1000 cells. but the month name and range changes according to row and column of every cell. How can I change the formula of every cell without selecting each cell and editing manually? I would be very much thankful if anyone can help me with this problem. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro help for changing data (cell location) in edit find box | Excel Discussion (Misc queries) | |||
| can't edit a cell with a formula | Excel Worksheet Functions | |||
| i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
| How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
| edit number in cell without it changing to text | Excel Discussion (Misc queries) | |||
Threaded Mode
