Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing A1:B2 with a "TEXTED CONTENT"
In using DMAX(D2:F1000;"Profit"; P45:P46 ) y need to replace the last term
***P45:P46*** for an content I have in field P45:Q45, or by a one I produce as TEXT. I tried P45&Q45 but it didnt work. How can I replace this? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing A1:B2 with a "TEXTED CONTENT"
Third parameter is the criteria with label in P45 and condition in P46.
You can change it to P45:Q46 if you have two conditions... but not P45:P46 "Martinj" wrote: In using DMAX(D2:F1000;"Profit"; P45:P46 ) y need to replace the last term ***P45:P46*** for an content I have in field P45:Q45, or by a one I produce as TEXT. I tried P45&Q45 but it didnt work. How can I replace this? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
How do I stop Excel from replacing "(c)" with copyright symbol? | Excel Discussion (Misc queries) | |||
Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |