| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Average using alphanumerics
I have places in a spreadsheet column 1st, 2nd, 3rd... How do I get an
average to show those alphanumeric characters? I can do straight numerals but with the alpha included it has me baffled, which doesn't take much... Thanks! |
|
#2
|
|||
|
|||
|
Hi
nay chance to stripe the alpha characters from your values -- Regards Frank Kabel Frankfurt, Germany "JohnT" schrieb im Newsbeitrag ... I have places in a spreadsheet column 1st, 2nd, 3rd... How do I get an average to show those alphanumeric characters? I can do straight numerals but with the alpha included it has me baffled, which doesn't take much... Thanks! |
|
#3
|
|||
|
|||
|
Hi!
Assuming that these are all typical ordinal numbers, try this array formula and enter with the key combo of CTRL,SHIFT,ENTER: =AVERAGE(--LEFT(A1:A10,LEN(A1:A10)-2)) Biff -----Original Message----- I have places in a spreadsheet column 1st, 2nd, 3rd... How do I get an average to show those alphanumeric characters? I can do straight numerals but with the alpha included it has me baffled, which doesn't take much... Thanks! . |
|
#4
|
|||
|
|||
|
Yes, I can strip them but was wondering if there was a way to show. I guess I
could create a work area that defines 1=1st, 2=2nd and so on... "Frank Kabel" wrote: Hi nay chance to stripe the alpha characters from your values -- Regards Frank Kabel Frankfurt, Germany "JohnT" schrieb im Newsbeitrag ... I have places in a spreadsheet column 1st, 2nd, 3rd... How do I get an average to show those alphanumeric characters? I can do straight numerals but with the alpha included it has me baffled, which doesn't take much... Thanks! |
|
#5
|
|||
|
|||
|
Thanks Biff, I'll try it in the morning... 11:47 PM here in Kent, WA and I
gotta get up in a few hours. Thanks again! "Biff" wrote: Hi! Assuming that these are all typical ordinal numbers, try this array formula and enter with the key combo of CTRL,SHIFT,ENTER: =AVERAGE(--LEFT(A1:A10,LEN(A1:A10)-2)) Biff -----Original Message----- I have places in a spreadsheet column 1st, 2nd, 3rd... How do I get an average to show those alphanumeric characters? I can do straight numerals but with the alpha included it has me baffled, which doesn't take much... Thanks! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate average hours and minutes | Excel Worksheet Functions | |||
| calculate average hours worked | Excel Worksheet Functions | |||
| average, array and offsets | Excel Worksheet Functions | |||
| Average determination | Excel Worksheet Functions | |||
| Average Formula | Excel Worksheet Functions | |||
Linear Mode
