troubleshooting Question

I need an OFFSET formula

Avatar of wrt1mea
wrt1mea asked on
Microsoft Excel
8 Comments1 Solution334 ViewsLast Modified:
I need help using the OFFSET formula to auto update the graph information in Excel. I have tried using the following formula, but keep getting errors:

=OFFSET(Patient Info!$A$13,0,0,COUNTA(Patient Info!$A:$A)-1)

I need the graph on the patient info tab to automatically update the graph when new data is entered in A13: B37.

I tried using the embedded table route, but ran into problems when a line had to be deleted because of errors / ommissions from data entry.

I would prefer to be able to use the offset function if possible. See attached.
2-7-12.xlsx
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 8 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros