Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FILTER CELLS CONTAINING FORMULAS
I have quite a huge list and have to insert different sort of formulas
depending upon the criteria. In the end I am most of the time in a doubt whether all the cells are containing formulas or there still exist some figures inserted manually. Could there be some kind of formula resulting as "=ISFORMULA(A1)" reflecting whether A1 contains any formula or not? Thanx! -- Best Regards, FARAZ A. QURESHI |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
FILTER CELLS CONTAINING FORMULAS
"=ISFORMULA(A1)"
Trawling google reveals this UDF (add to a general module in your workbook) Function IsFormula(Cell) IsFormula = Cell.HasFormula End Function Then you could use it eg in E2, copied down: = --isformula(D2) Col E will return 1's for cells in col D with formulas, zeros for cells w/o formulas -- Max Singapore http://savefile.com/projects/236895 Downloads:17,000 Files:358 Subscribers:55 xdemechanik --- "FARAZ QURESHI" wrote: I have quite a huge list and have to insert different sort of formulas depending upon the criteria. In the end I am most of the time in a doubt whether all the cells are containing formulas or there still exist some figures inserted manually. Could there be some kind of formula resulting as "=ISFORMULA(A1)" reflecting whether A1 contains any formula or not? Thanx! -- Best Regards, FARAZ A. QURESHI |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
FILTER CELLS CONTAINING FORMULAS
HEY MAX
U'R THE BEST THANX!!!!!!!!! -- Best Regards, FARAZ A. QURESHI "Max" wrote: "=ISFORMULA(A1)" Trawling google reveals this UDF (add to a general module in your workbook) Function IsFormula(Cell) IsFormula = Cell.HasFormula End Function Then you could use it eg in E2, copied down: = --isformula(D2) Col E will return 1's for cells in col D with formulas, zeros for cells w/o formulas -- Max Singapore http://savefile.com/projects/236895 Downloads:17,000 Files:358 Subscribers:55 xdemechanik --- "FARAZ QURESHI" wrote: I have quite a huge list and have to insert different sort of formulas depending upon the criteria. In the end I am most of the time in a doubt whether all the cells are containing formulas or there still exist some figures inserted manually. Could there be some kind of formula resulting as "=ISFORMULA(A1)" reflecting whether A1 contains any formula or not? Thanx! -- Best Regards, FARAZ A. QURESHI |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
FILTER CELLS CONTAINING FORMULAS
Perhaps you can make use of this technique. Select all the cells you want to
check, click Edit/Find in Excel's menu bar (or just key in Ctrl+F instead) to bring up the Find dialog box. If the extra options are not showing, click the "Options" button to display them. Type =* (the is equal sign, asterisk) in the "Find what" field, select "Sheet" in the "Look in" drop down, select "Formulas" in the "Look in" drop down, then click the "Find All" button and follow that by keying in Ctrl+A. Finally, click the Close button and all cells **with** formulas in them will be selected... you will want to concentrate on the cells *not* selected. Rick "FARAZ QURESHI" wrote in message ... I have quite a huge list and have to insert different sort of formulas depending upon the criteria. In the end I am most of the time in a doubt whether all the cells are containing formulas or there still exist some figures inserted manually. Could there be some kind of formula resulting as "=ISFORMULA(A1)" reflecting whether A1 contains any formula or not? Thanx! -- Best Regards, FARAZ A. QURESHI |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
FILTER CELLS CONTAINING FORMULAS
Welcome, glad it helped.
-- Max Singapore http://savefile.com/projects/236895 Downloads:17,000, Files:358, Subscribers:55 xdemechanik --- "FARAZ QURESHI" wrote in message ... HEY MAX U'R THE BEST THANX!!!!!!!!! -- Best Regards, FARAZ A. QURESHI |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
FILTER CELLS CONTAINING FORMULAS
Another way is to Select the column and use F5 Special
And check formulas. All cells with a formula are selected now -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "FARAZ QURESHI" wrote in message ... I have quite a huge list and have to insert different sort of formulas depending upon the criteria. In the end I am most of the time in a doubt whether all the cells are containing formulas or there still exist some figures inserted manually. Could there be some kind of formula resulting as "=ISFORMULA(A1)" reflecting whether A1 contains any formula or not? Thanx! -- Best Regards, FARAZ A. QURESHI |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
formulas in cells change when using filter function | Excel Discussion (Misc queries) | |||
How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
Any way to filter cells with formulas ? | Excel Discussion (Misc queries) | |||
filter for non-formulas | Excel Discussion (Misc queries) |