Forum Discussion

doraymi's avatar
doraymi
Copper Contributor
Apr 20, 2019
Solved

Excel formula Help

Hi all,   I have a problems on my formula.  I have two worksheet 1 and 2.  for worksheet 1, the yellow highlighted contains all the country name but i have to use worksheet 2 as a data set (green...
excel
Formulas and Functions
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Apr 20, 2019

doraymi 

For the country name in F2:

=VLOOKUP(F2,Sheet2!$A$2:$B$9,2,FALSE)
  • doraymi's avatar
    doraymi
    Copper Contributor
    Apr 20, 2019

    Detlef_Lewin Big thanks for your prompt reply! i've got the desired result. I would like to ask a more questions...after searching the frequency for each column (F, H, J, L, N, P and R) and gives out column (G, I, K, M, O and Q), can I further sort out all the 'High' frequency country?(say for row 2, sort out Thailand, Hong Kong, Indonesia and Thailand), in order to achieve the goal in presenting the countries which have high frequency against the company name (column c) in pivot table. thanks.

    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Apr 20, 2019

      doraymi 

      Could you provide a file with your desired result? What should the pivot table look like?

       

      • doraymi's avatar
        doraymi
        Copper Contributor
        Apr 20, 2019
        this would be my desired result, in which list out the most high frequency (might not more than one country) against list of companies

Resources