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
Last Comment
Shums Faruk
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
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thanks for your hard work
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
