vijay vj
asked on
Excel formula to return X:Y axis in a cell
Dear sir, i have matrix table in excel where its shows correlation between two stocks, i need to pick stocks if it has above 90% and between 80-90 % and so on .
1.jpg
1.jpg
It would be helpful, if you upload sample workbook
ASKER
check the matrix table and i need result as X:Y = 90 % so on
NSE-Data.xlsm
NSE-Data.xlsm
Vijay,
It would be much easier to have Conditional formatting which will highlights both X & Y axis way.
Please find attached...
NSE-Data_V2.xlsm
It would be much easier to have Conditional formatting which will highlights both X & Y axis way.
Please find attached...
NSE-Data_V2.xlsm
ASKER
IS it possible to pick that 90% or 80% separately sir
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks for your hard work