Smart Excel macro problem
[Users questions | Browse:27 | Favorites]
Users questions: Cell A1 = 0B as containing E, F, G of the text value of each text value of this column corresponds to a data in the C column. Such as B5 = E, then the C5 on a number of 2.4 corresponds to the D1 is now set up a function, so when when A1 = F, D1 is equal to column B "F" corresponds to the C column Values .. that is, when A1 = F, the function automatically find the value column B, when a grid is F, then A1 is equivalent to the F value corresponding to the C column. Such as B column B7 = F, then A1 = C7, if B9 = F, then A1 = C9 confused, wrong word, correct it: 4 lines from the beginning, "when a cell is F, then F D1 is equivalent to the value corresponding to the C column. In A1 = F of the premise, such as B7 = F, then D1 = C7, such as B9 = F, then D1 = C9
Experts answer: inconsistency problem - whether it is equal to C out values A1, or D1 Value equal to C out then? For the time being by "D1 is equal to B column" F "corresponds to the C column values" Resolution: D1 = index (c: c, match ($ a $ 1, b: b, 0)) press ctrl + shift + enter three key enter the array formula.
Experts answer: inconsistency problem - whether it is equal to C out values A1, or D1 Value equal to C out then? For the time being by "D1 is equal to B column" F "corresponds to the C column values" Resolution: D1 = index (c: c, match ($ a $ 1, b: b, 0)) press ctrl + shift + enter three key enter the array formula.
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- excel how to filter and distinguish between the number of consecutive
- How will the characters in the cell and breakdown of figures show?
- How to set excel in the integer "0" format
- How to convert PDF text editable word or TXT
- How could such a problem?
- Help explain, EXCEL function of usage, there are accessories.
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.