Small help- in excel

[madhanji]

Dear Seniors & Experts,
please request a small help in excel.

Column A have some Fruits and column B has the month ,
i need Result in "C" column based on the month order, not in fruits order.
for example , first time
i tried "Month formula abut not able to get desired result.
pls some one help me.

Thanks in advance.

 

[awoohaw]

You have not addressed if you want to point to Column B instead of Column C.
but there are a few other issues:
1. You are using the TODAY() function, it is now 1 MAY, so the months change. Is this something you want pertpetuated? as the values change each month.
2. What do you do when the year of today is different from the year of the month value in column B.

Why don't you tell us what your objective is? What is it you are trying to figure out from the data values?

 

[madhanji]

Dear @awoohaw sir, S, if month changed then current month should be " I " , But pls ignore my formula, I tried right formula but not get desired result .bcas for example if "B-column date goes 01-04-2024 we can't loop if condition long ..

so pls find the solution as your way sir

 

[madhanji]

OR SIMPLY provide solution to this query

multiple same strings in column A, so need order it like I,II,III

 

[awoohaw]

Is your request to count the difference of months as a ROMAN Numeral?
There is a function called ROMAN in excel 365 but not 2010.

If you want roman, how large will your counts of each value go?

Is there a reason why you want roman numerals?

 

[fjns]

Hi, see the linked file for a possible solution...

The formula used in the table...
C1: =IF(A1="","",IF(AND(COUNTIF(A:A,A1)-COUNTIFS(A:A,A1,B:B,">"&B1)>0,COUNTIF(A:A,A1)-COUNTIFS(A:A,A1,B:B,">"&B1)<4),REPT("I",COUNTIF(A:A,A1)-COUNTIFS(A:A,A1,B:B,">"&B1)),"ERROR")) (Range: C1:C25 ...)

FruitsOrder.xlsx

 

[awoohaw]

This is not ROMAN numerals, but it repeats the "I":

Book4
	A	B
1	FRUIT
2	apple	I
3	apple	II
4	apple	III
5	orange	I
6	orange	II
7	orange	III
8	orange	IIII
9	pineapple	I
10	pineapple	II
11	pineapple	III
12	mango	I
13	mango	II
14	mango	III
15	mango	IIII
16	watermelon	I
17	watermelon	II
18	watermelon	III
19	pappaya	I
20	pappaya	II
21	pappaya	III
Sheet2

Cell Formulas
Range	Formula
B2:B21	B2	=REPT("I",COUNTIF($A$2:A2,A2))

 

[fjns]

Hi, I created another solution with the ROMAN function also recommended by awoohaw for Office 365.

The formula used in the new table...
C1: =LET(x,COUNTIF(A:A,A1)-COUNTIFS(A:A,A1,B:B,">"&B1),IF(A1="","",IF(x>0,ROMAN(x),""))) (Range: C1:C25 ...)

FruitsOrder2.xlsx

 

[Peter_SSs]

There is a function called ROMAN in excel 365 but not 2010.

According to ROMAN function - Microsoft Support the function is available in 2010

The formula used in the new table...
C1: =LET(x,COUNTIF(A:A,A1)-COUNTIFS(A:A,A1,B:B,">"&B1),IF(A1="","",IF(x>0,ROMAN(x),"")))

.. though if that does produce the results that the OP wants, then it would need to be re-written without the LET function as that is definitely not available in 2010 version

 

[awoohaw]

According to ROMAN function - Microsoft Support the function is available in 2010

thanks Peter, I wish I could remember where I saw that it was not. I hope a 2010 user will experiment with it for us.

Another page says 2007.

 

[madhanji]

Is your request to count the difference of months as a ROMAN Numeral?
There is a function called ROMAN in excel 365 but not 2010.

If you want roman, how large will your counts of each value go?

Is there a reason why you want roman numerals?

Dear sir, my request not to count the difference of month and month is the reference of column A because two more same fruits come in same , so i preferred column B as a reference to make column C
ROMAN is not NECCESSARY , NUMERICAL ALSO ENOUGH. But if we find the solution for Numeric then i will convert it again Roman with helper column.

If you want roman, how large will your counts of each value go?
S, this part I am struggling so asked help here..

Thanks for your attention to help me sir.