Formula to return symbols

  • Thread starter Thread starter s_a_burkey
  • Start date Start date
S

s_a_burkey

I'm trying to illustrate salary savings within my organisation and have
detailed savings on a number of schemes - I'd like to have the cost
savings in one column (already set up) but also to illustrate how may
people this could recruit next to it - ie I'd like to 'total
savings/average salary = potential new recruits' but to show this with
a webding of a little person - any ideas if this is possible?
 
I don't know what the letter for the person is but let's say it is an 'a'.
To get 9 of them say, use

=REPT("a",9)
 
One way would be to use a VLOOKUP formula with 1,2,3 peeps etc.........I
would suggest the TRUE option at the end.
For example:
=VLOOKUP(A1,H1:I5,2,TRUE)

Vaya con Dios,
Chuck, CABGx3
 
Back
Top