Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Prompt value in formula
I am using this formula in my company, but the procedure has now changed and
therefor the values ("204";"0"; etc.) has to be changed from time to time. Can someone show me a script so that the formula prompts for these values when i click on the cell??? I hope my question is understable and clear! :o) =SUMPRODUCT(('import part'!$A$2:INDEX('import part'!$A$1:$A$50000;TÆL('import part'!$E$1:$E$50000))="204")*('import part'!$B$2:INDEX('import part'!$B$1:$B $50000;TÆL('import part'!$E$1:$E$50000))="0")*('import part'!$G$2:INDEX ('import part'!$G$1:$G$50000;TÆL('import part'!$E$1:$E$50000))=8)*('import part'!$F$2:INDEX('import part'!$F$1:$F$50000;TÆL('import part'!$E$1:$E$50000)) <=2)*('import part'!$E$2:INDEX('import part'!$E$1:$E$50000;TÆL('import part'! $E$1:$E$50000))<27)*'import part'!$D$2:INDEX('import part'!$D$1:$D$50000;TÆL ('import part'!$E$1:$E$50000))) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200902/1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Read Only Prompt | Excel Discussion (Misc queries) | |||
save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
How do I enable Excel's "formula prompt?" | Excel Discussion (Misc queries) | |||
Save Prompt | Excel Worksheet Functions | |||
Help on Prompt | Excel Worksheet Functions |