Rookie- Convert The Scores To A Simple Number Value Additionally
Jan 16, 2010
I am doing a club handicap type of scoring awards for a waterski club
the info I get off the internet from each event is like this example below.
I need to convert the scores to a simple number value additionally if possible choose only the highest score since I only use one score from each event. some events have 2 or 3 scores per skier.
Then I have a vlookup table setup and functioning to bring the handicap to my main sheet.
John M44.00/1200
3.50/1200
2.00/1200
MARK M41.50/1125
2.00/1125
2.50/1200
DAVID M43.50/1425
1.50/1425
.50/2300
KEN M42.50/1300
5.50/1425
2.00/1425
basically if you replace the / with @ you have your score of 4@12 meters this being 6 more points than say 4@13 since the 12 meter rope is shorter and more difficult to get around the bouy.
So can or should I use a replace "/" with"@". but then what I ultimately need is like 4/12 need to return a number like 96 and 4/13 should give me 90.
Would a vlookup be easiest? Does excel have a function like this?
Additionally it would be great if it can choose the highest score and bring only that into the main sheet.
is these event do have non club members in then as well, can I using my existing vlookup sheet return only those names?
View 9 Replies
ADVERTISEMENT
Sep 13, 2012
I have a data example
Cell A1 which contain text I.E = "Words"
I have link B1 To cell A1 I.E = A1
Now what I want is I want the last two words or any alphabet between alphabet
to be bold
W O R D
Example
WORD or WORD
Any alphabet between word to be bold upon my requirement.
Instead of linking that cell to another cell , i want any value when entered into that cell.
That alphabet automatically becomes bold as this will not be requiring linking to that cell
View 4 Replies
View Related
May 10, 2007
The following formula is to add up the 4 highest scores for members belonging to each group:
= SUM(LARGE(($A$2:$A$499=Y2)*($C$2:$C$499),{1,2,3,4})) (entered as an array)
I only want to return results for groups that have four or more members. I am not interested in groups that say only have 3 members.
How can I modify this formula to do this?
View 9 Replies
View Related
May 17, 2007
Just looking at the first or second Column, need to Hide all ROWS which either contain "#VALUE!" or "N/A".... The sheet data changes for any age the user input...
View 9 Replies
View Related
Nov 19, 2006
i wanto set up validation in two collmuns of data the collumns are g and h. the validation that i have set up in g2 is whole number <h2. this works but i want to do this in the whole collumn of g. for example i want the validation in g3 to be <h3.
also the validation in h2 is >g2, what i want is basically to set up a formulae to copy these 2 validations down the colummns,
View 9 Replies
View Related
Jun 22, 2012
Is there a simple function for calculating the number of months between 2 dates.
Eg 1/5/2012 - 8/9/2020
View 1 Replies
View Related
Aug 17, 2009
There are scores in B1:B10 (10 scores). I want to take the top 8 scores. So I used this formula which works just fine.
=SUM(LARGE(B1:B10,1),LARGE(B1:B10,2),LARGE(B1:B10,3),LARGE(B1:B10,4),LARGE(B1:B10,5),LARGE(B1:B10,6) ,LARGE(B1:B10,7),LARGE(B1:B10,8))
But I'm trying to make the formula a bit more dynamic. Is there anyway to have a set of data in B1:B50 (50 scores will probably be the most) and take the top x scores? X will be set in a separate cell (lets just say A1)?
View 5 Replies
View Related
Feb 13, 2008
I have a raw score for each case. I need to map those raw scores to scale scores. For example, a raw score of 0 to 0.49 maps to a scale score of 120, a raw score of 0.5 to 0.99 maps to a scaled score of 110, etc. There are a total of 13 possible scaled scores (120, 110, 100, ... 20, 10, 0). Is there a way to do this in Excel2003? (Note, if anyone on the list is 'bilingual' (Excel and SPSS), I'm looking for the Excel equivalent of the SPSS command RECODE raw (lo thur .49=120), (.5 thru .99=110), etc. INTO scale.
View 2 Replies
View Related
Oct 23, 2011
I have a problem that when I try to convert text to number and format the number without 2 decimal places as seen on the link I have given below, Instead of 1607.947, I get 1607947. I have Excel 2010 loaded. The details are in below picture.
[URL]
View 4 Replies
View Related
May 29, 2008
Does clipboard method gettext retreive the text from clipboard only, not number? What if numbers are copied (Ctrl C) to clipboard?
View 9 Replies
View Related
Nov 7, 2006
i have this function that poulates data from a userform into a sheet.
For lLoop = 1 To MAWBNoVar
With Range("B" & Rows.Count).End(xlUp)
.Offset(1, 0) = Controls("txtMAWB" & lLoop)
.Offset(1, 1) = Left(Controls("cbDestination" & lLoop), 3)
.Offset(1, 2) = Controls("txtGW" & lLoop)
.Offset(1, 3) = Controls("txtCBM" & lLoop)
.Offset(1, 4) = "= ROUND(E" & Y & "*167,0)"
.Offset(1, 5) = "=IF(D" & Y & ">F" & Y & ",D" & Y & ",F" & Y & ")"
.Offset(1, 6) = "=IF(F" & Y & ">D" & Y & ",G" & Y & "-D" & Y & ",G" & Y & "-F" & Y & ")"
Y = Y + 1
End With
Next lLoop
My problem is that the data being entered into the sheet for the lines highlighted in red is going in as text, and not true numerics, so that the subsequent formulae are not working correctly.
View 3 Replies
View Related
Nov 11, 2008
I'm just trying to get a total of columns E, F and G, and place those totals in row 5. The problem is that somehow the numbers in column G were stored as text, so the SUM formula is coming up "0". How would I format these cells, in a macro, (columns E, F and G, just in case the data in the other two columns were stored as text), as a number so that I can total them.
I've tried selecting the column, selecting format cells and choosing number, but that doesn't work. I can manually select the cells, click the little exclamation point, and then tell it to convert to number. This works, but when I tried to record it to add it to the macro, it didn't record anything but the selection of the cells.
View 2 Replies
View Related
Jul 28, 2009
I have a string of imported data which comes into an existing spreadsheet. It cannot be changed prior to importing as the data is provided by an external vendor.
When the data is imported into my spreadsheet the Error Checking tag comes on, after I select the cells where certain numeric data has been entered, stating that this is a range of Numbers Stored as Text. If I click on the Error Checking tag and select the Convert to Number option and then enter my VLOOKUP function I get the desired answer. If I do not convert the text to numbers then my VLOOKUP function does not work at all. The cell just displays the function text itself instead of the desired answer.
Here is what I am requesting:
Assistance with writing the VBA code to accomplish the manual task of converting the text to numbers. I have tried to format using the Ribbon without success.
View 9 Replies
View Related
Oct 31, 2009
when i import some data from web
some of the character show ¾ or 1½ ..these look like a word rather than number
so may i know how can i convert "1½" to 1.5?
View 9 Replies
View Related
May 14, 2007
I have a combobox embedded into an excel sheet with a linked cell and a range defined in the combobox properties. Every time I change the value in the combobox, the value in the linked cell is stored as text instead of a number.
I have tried copying a cell containing 1 and copying and pasting as special into the linked cell but that only fixes it for the time being. If I change the value in the combobox again, the value in the linked cell is again stored as text. I tried =value() in the linked cell but that again only worked temporarily. Every time I change the value in the combobox, the value in the linked cell is stored as text.
View 13 Replies
View Related
Jan 11, 2013
I have a date in a particular cell, say O5, formatted as mm/dd; e.g. 11/14
I have the following formula in another cell;
=M5 &", Lot# "& N5 &", Expires "& O5, where cell M5 = "CONTROL" and cell N5 = "#####"
Why does the date get converted to a serial number. i.e. CONTROL, Lot# #####, Expires 41592?
My aim is to get the date "11/14" to appear in the cell.
View 1 Replies
View Related
Jan 15, 2013
I am trying to convert the name of a month to a number but there is a slight issue with using my normal method of TEXT("1/"&A1&"/2013","mmm")
I am trying to create a dynamic table which if you change 1 value for the month, it changes others
so my data looks like so,
Jan
Feb
Mar
Apr
May <---- this is the value which is chosen
The problem is when I select the month "January", it assigns the value of the above cell as 1/0/2013 which is not a date when in fact I want to set it as "December".
View 4 Replies
View Related
Feb 1, 2013
Here how to convert Number to Text..Like 100 means One Hundred.For this any formula is there? i want to change Full A Column numbers to Text..Number To Text.jpg
View 2 Replies
View Related
Aug 30, 2013
I exported a report from Crystal to Excel. The times came over as numbers. How do I convert the numbers into time.
Example: 753 to 7:53
1426 to 14:26
View 4 Replies
View Related
Jul 23, 2009
Is there simple function that anyone knows of (or has written) that will convert a letter to its alpha-numeric equivalent?
For instance, A = 1, B = 2, AA = 27, etc (a = 1, b = 2, aa = 27)
View 6 Replies
View Related
Sep 16, 2009
i have number in database 1 and want to convert as date in database 2
04079219920506
04089219920507
04099219920510
18730120010729
18740120010801
18750120010804
18760120010805
result in database 2
407/9206/05/1992
408/9207/05/1992
408/9210/05/1992
1873/0129/07/2001
1874/0101/08/2001
1875/0104/08/2001
1876/0105/08/2001
is it got any formula to convert this number from database 1 to database 2, so far i has attach sample files..
View 5 Replies
View Related
Feb 13, 2013
Need to convert number to identical quantity of spaces. Example:
A1 is 5
B1 should consist 5 spaces (or other characters).
View 1 Replies
View Related
Apr 11, 2007
Converting Number into text I have tried to look for a formula but have not go any
Is there any way to convert them in indian currency format of Lakhs
like Rs 1,50,450 or Rs One lakh fifty thousand four hundred fifty only
View 9 Replies
View Related
Jun 7, 2009
I'm trying to write a macro that will convert a number into text but can't hone in on the right coding
here's what I want to do:
a.) I select a cell in my spreadsheet that contains a number, it can be in any format ie: 100, 7.7442, 22.3
b.) I launch the macro
c.) the macro converts the number into text and adds the letter T in the front so the new cell value becomes: T100, T7.7442, T22.3
View 9 Replies
View Related
Sep 4, 2009
I need a formula to take the numbers listed in cells D4:D50
If below 1,000,000 than just keep that number value
EXAMPLE DATA
If the Ten Thousands place is 5 or below leave the same if it is higher round up. (use this concept for ALL PLACE VALUES
1,500,000 to 1.5 million (if the rest are zeros)
4,000,000 to 4 million
1,564,535 than to 1.57 million
1,545,535 than to 1.54 million
1,555,000 than to 1.55 million
Same concept for the rest as the Millions (move the rounded place up as needed)
So for Billions it would be 10 Millions place (to round form) I think lol
1,000,000,000 to 1 Billion
1,500,000,000 to 1.5 Billion
1,560,000,000 to 1.57 Billion
1,578,000,000 to 1.58 Billion
1,700,000,000 to 1.7 Billion
I would like this to continue all the way up to place value 999 QUADILLION! (if possible) if the value can go bigger that would be great!
View 9 Replies
View Related
Jan 13, 2010
1000 = 1 minute
3000 = 20 seconds
and
100 = 10 minutes
What would be the forumla for converting these figures into time? These are just examples another one would be 275 = 3 minutes 38 seconds
Better yet here is the whole scoop.
Speed = 1000
Distance = 1.0 (i.e. mile)
Time = 00:01:00.0
I know these facts.
View 9 Replies
View Related
Apr 6, 2007
I saw the =WEEKNUM function introduced to Dave196. I tried it but I do not get the desired result. I get "# NAME?" What can I be doing wrong? Also, how can I have Excel take a date and convert it to a number? I want to convert a date into an invoice number (eg. 4/5/07 ===> 20070405)
View 2 Replies
View Related
May 24, 2008
I have a column formated as text that i need to convert to numbers.
Example: 0.01 (text format) into 0.01 (number format)
View 7 Replies
View Related
Nov 12, 2012
I keep getting the correct answer, but it returns it as negative and I need a positive answer.
View 1 Replies
View Related
Jan 29, 2013
I have a number and i wanted to convert it to a number or character.
Ex.
if i have value of 7, should be converted to a character of "*", the output will be 7 times of "*" (*******)
if value is 10, so it will be 10 times "*". (**********)
View 2 Replies
View Related
