How do we convert numbers to words. Especially useful if you are writing cheques (checks) through printing through a soft file. The logic given below is one for India – it uses crores and lacs. The logic works for all numbers between 1 and 99,99,99,999 (100 crore -1) Say the numbers that need to be [...]
Posts Tagged ‘concatenate’
Converting numbers to words
Posted in Tip, tagged concatenate, Left, Len, mid, proper, Right, rounddown, sum, value, vlookup on June 5, 2009 | 1 Comment »
Multiple extraction through vlookup
Posted in Uncategorized, tagged column(), concatenate, countif, index, match, offset, vlookup on May 4, 2009 | 2 Comments »
The problem here is extraction of multiple results from a two column array through a vlookup The data available is given in columns B and D. The 4 regions along with their major cities are known. The data needs to be arranged as in the table below Start by sorting on region (column B) [...]
Author
Search blog
-
Recent posts
-
Blog Stats
- 15,059 hits
Share with others!
What have I used most
Get down to work!
May 2012 M T W T F S S « Jul 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
