I need the revenue and cost per company to be added in B3:C7 when I specify the dates I want in F3 and F4.
Thanks for the help!
I need the revenue and cost per company to be added in B3:C7 when I specify the dates I want in F3 and F4.
Thanks for the help!
This is an array formula solution that will require a modification in the data arrangement, as in the date needs to be placed above the Revenue and cost columns. Once that has been done paste this formula in B3, press the F2 key, then press the Ctrl, Shift and Enter keys simultaneously:Here is a copy of your file with the modifications and formula applied: Copy of Revenue&Cost.xlsmPlease Login or Register to view this content.
Let me know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Here is an array formula* that will allow the date to be centered over the "Revenue" column only as in the original version of the file attached to post #1:*Paste the array formula in B3, press the F2 key, press the Ctrl, Shift, and Enter keys simultaneously, Copy down to B7 and across C7.Please Login or Register to view this content.
Let me know if you have any questions.
Thank you so much works great!
You're Welcome and thank you for the feedback. If you haven't already please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a good day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks