Link to home
Start Free TrialLog in
Avatar of vijay vj
vijay vjFlag for India

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
Avatar of Shums Faruk
Shums Faruk
Flag of India image

It would be helpful, if you upload sample workbook
Avatar of vijay vj

ASKER

check the matrix table and i need result as X:Y = 90 % so on
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
IS it possible to pick that 90% or 80% separately sir
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks for your hard work