Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write a formula for column F that places the date of the first value that is greater than zero. For example, F3 should says 03/31/2003
Write a formula for column F that places the date of the first value that is greater than zero. For example, F3 should says 03/31/2003 because the date of the revenue is March. If there is already a value beginning 01/31/2020, then the cell should say 01/31/2020. For example, cells F4, F5, and F6, should say 01/31/2020. Cell F7 should say 02/29/2020
My thought is it should probably be a index(match formula or something similar
\begin{tabular}{l|lrrrr} & A & B & \multicolumn{1}{c}{ C } & \multicolumn{1}{c}{ D } & F \\ \hline 1 & & 01/31/2020 & 02/29/2020 & 03/31/2020 & \multicolumn{1}{c}{04/30/2020} \\ \hline 2 & Parent Customers & & & & \\ 3 & Client 1 & 0.00 & 0.00 & 2,670.33 & 3,247.05 \\ 4 & Client 2 & 12,469.35 & 10,435.62 & 9,771.94 & 16,091.57 \\ 5 & Client 3 & 23,621.40 & 18,954.14 & 18,198.91 & 17,489.96 \\ 6 & Client 4 & 7,620.76 & 3,501.79 & 3,952.04 & 1,748.57 \\ 7 & Cleint 5 & 0.00 & 4,630.96 & 1,741.20 & 849.36 \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started