LinkBack URL
About LinkBacks
Hello,
I have the following function =MAX(INDIRECT”B1:F1”)). When I copy/drag this formula down, B1:F1 stay the same. I need it to change and become B2:F2, etc.
Thanks for you help!
Hello,
I have the following function =MAX(INDIRECT”B1:F1”)). When I copy/drag this formula down, B1:F1 stay the same. I need it to change and become B2:F2, etc.
Thanks for you help!
=MAX(INDIRECT”B1:F1”))
Does this (it) work for you?
Please show it in an excel file, without confidential information.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Why not just
=MAX(B1:F1)
Why the use of Indirect?
Hi and welcome to the forum
maybe this?
=MAX(INDIRECT”B"&row(a1)&":F"&row(a1)))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I have included an attachment. That formula works, but doesn't work when I copy it down the column. The cell highlighted in yellow should be 6.
When we add columns to the spreadsheet the range changes.
Try
=MAX(INDIRECT("B" &ROW()&":F"&ROW()))
I get an error when I try this formula.
You can use the formulat of Jonmo1.
I tested the formula, and of course it works.
You are correct. It works. THANKS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks