Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 390
  • Last Modified:

Excel Formula

Hi Expert,

I am using Match Function but I don’t know why result is coming as expected. See attached file - Sheet Calculation - Highlighted Yellow Section.


Thank You
Z-Score.xlsm
0
Naresh Patel
Asked:
Naresh Patel
  • 6
  • 5
1 Solution
 
gowflowCommented:
For Col I the result is correct as you started at A2
Start at A1 and you will get 140 with is the row that matches with value of I32

You have mixed between Row and Column the rest are ok

check the attached file.
gowflow
Z-Score.xlsm
0
 
Naresh PatelTraderAuthor Commented:
Thank you Very Much.....
0
 
gowflowCommented:
In this version I added the translation of Column in letters maybe it is more handy.
Rgds/gowflow
Z-Score.xlsm
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Naresh PatelTraderAuthor Commented:
Thank You much this is what I needed, but there is some problem while column comes under A to Z i.e. 1 to 26 i.e. result shows @F. I don't know how come "@" come from. If you are interested further help me beyond this then Scoring Simplified or pls let me know how do I rectify "@" problem.


Thanks.
0
 
gowflowCommented:
yes for sure I will look at it and also while driving after posting the solution I will need to revise it if you have data in columns like ABC or ADX etc... 3 letters. Give me 1 hour will get back to you hv to go lunch.

gowflow
0
 
Naresh PatelTraderAuthor Commented:
ok awaiting for your response....thanks
0
 
Naresh PatelTraderAuthor Commented:
May be I will reply your post after 30 min as I on my way back to Home.


Thanks
0
 
gowflowCommented:
ok here it is. value of columns wether 1 digit 2 or 3 will come out correctly. To test it just put any sequence say ABC 20 XX in any column say AAF or BDK or M or FG and see if it comes out correctly.
gowflow
Z-Score.xlsm
0
 
Naresh PatelTraderAuthor Commented:
Sure I will , one more thing you are going to see my next question?
0
 
gowflowCommented:
If you can wait 1 hour before you post it for sure as I have to go take my kids to music or else for sure you will get help in here as Experts don't loose time to provide support. Your choice.

If you want my assistance I will drop a line as soon as I am back.
gowflow
0
 
Naresh PatelTraderAuthor Commented:
I prefer to wait but I had already raised the new question. Do you want me to delete that one.or you just drop one line in that question so no other will attend that question.

Thanks
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now