Forum Discussion
Filtering a group of data with two separate values.
I don't have 365, I made the code partially with props. I can't use this code and I realized that I wrote the topic incompletely. outside the main topic
I have one more question.
1) I need to subtract all but Q1 (**/3) for quarterly net worth.
I could do it using if, but I'd stretch this long formula even further.
Instead of entering the formula one by one as in the dark blue region, I want to see the same result as a group as in the yellow region at once.
which sheet is your raw data?
which range is your expected result?
hi peiyezhu
raw data and result are on the same page.
**/3 = YY/3
My sample file is attached.
highlighted in blue,
The numerical results I want. However, instead of entering these data into each cell one by one, I want to obtain them with a single formula as in yellow. The formula in the yellow field returns the searched data as a group. however, these figures are data covering a certain period. I want to get this data with a single formula and quarterly figures.
end
If YY/3-6-9-12 = 3, the data in that column should be written exactly,
if not; the data in the column should be subtracted from the data in the previous column.
thanks.- **/3 = YY/3
what are these asterisks mean?
YY/3-6-9-12 = 3,
what does YY mean?
=LET(a,A9:A16,b,MATCH(Q20,A6:AXX6,0),FILTER(A9:AXX16,(COLUMN(A6:AXX6)=2)+((COLUMN(A6:AXX6)>=b)*(COLUMN(A6:AXX6)<=b+5)))) / LET(Price,FILTER(TCMB_Kur,TCMB_Kur[Döviz Cinsi]=P19),INDEX(Price,SEQUENCE(1,6,2)))
I have found above formula in range("Q22") (which is in yellow expected result range),have you solved it?
Sorry,I am lost.- 2023/3
** or YY meaning year,
3 first quarter in finance
