We help IT Professionals succeed at work.

Excel formula to return X:Y axis in a cell

164 Views
Last Modified: 2017-03-15
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
Comment
Watch Question

ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
It would be helpful, if you upload sample workbook

Author

Commented:
check the matrix table and i need result as X:Y = 90 % so on
NSE-Data.xlsm
ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
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

Author

Commented:
IS it possible to pick that 90% or 80% separately sir
Managing Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
thanks for your hard work