login
Need Excel Help
-
No new posts
|
  2007-08-23 2:18 PM |
 Subject: ...This user's post has been ignored. |
| 2007-08-23 2:21 PM in reply to: #937984 |
Master 2379    Alpharetta, GA | Subject: RE: Need Excel Help Off the top of my head, you're probably going to want to use the LEFT function...I'd have to look up to get exact format...hope this helps a little. |
| 2007-08-23 2:22 PM in reply to: #937984 |
Champion 6786   Two seat rocket plane | Subject: RE: Need Excel Help You could copy the column only to a text file and then open it as a delimited file, using the decimal point as a delimiter, delete the extra columns and then copy-paste it back into the spread sheet. That's kind of a kludge, but I think it'll work. |
| 2007-08-23 2:23 PM in reply to: #937984 |
| Master 2379 Alpharetta, GA | Subject: RE: Need Excel Help Yeah...in a new cell, use the formula: =LEFT(D4, 7), where D4 = your starting row... |
| 2007-08-23 2:26 PM in reply to: #938000 |
| Subject: ... This user's post has been ignored. |
| 2007-08-23 2:27 PM in reply to: #938011 |
| Master 2379 Alpharetta, GA | Subject: RE: Need Excel Help Lara - 2007-08-23 3:26 PM Ironicly D4 was the right cell/row... TA-DA!!
glad I could |
| 2007-08-23 2:52 PM in reply to: #937984 |
| Elite 4504 Columbus, Ohio | Subject: RE: Need Excel Help The function MID would also work. Text = whatever cell Start = 1 Number=7 =MID(D4,1,7) The function has a lot more useability then LEFT, because you can pull from any point within the data Example: AH.0042.... you want 0042 Text = whatever cell Start = 3 Number = 4 =MID(D4,3,4) Edited by JChristoff 2007-08-23 2:55 PM |
| 2007-08-23 3:26 PM in reply to: #938011 |
| Extreme Veteran 832 Podunk County, MN | Subject: RE: Need Excel Help Lara - 2007-08-23 2:26 PM LHablas - 2007-08-23 12:23 PM Yeah...in a new cell, use the formula: =LEFT(D4, 7), where D4 = your starting row... PERFECT!!! THANK YOU!!!! Ironicly D4 was the right cell/row... Dude, that's not irony, that's coincidence. I really hate that when people do that. And btw, thanks for this example of using the left function. I'd forgotten about that handy little thing, and I've got something going that it's perfect for. |
| 2007-08-23 3:41 PM in reply to: #938077 |
| Master 2379 Alpharetta, GA | Subject: RE: Need Excel Help JChristoff - 2007-08-23 3:52 PM The function MID would also work. Text = whatever cell Start = 1 Number=7 =MID(D4,1,7) The function has a lot more useability then LEFT, because you can pull from any point within the data Example: AH.0042.... you want 0042 Text = whatever cell Start = 3 Number = 4 =MID(D4,3,4) Lighten up, dude, it's not a competition...she asked a simple question, I gave her a simple answer....MID's great, so is RIGHT, & TRIM (LTRIM and RTRIM in SQL), etc. come in handy too...they wouldn't exist if they didn't serve a purpose...just saying.... |
| 2007-08-27 10:34 AM in reply to: #938227 |
| Elite 4504 Columbus, Ohio | Subject: RE: Need Excel Help LHablas - 2007-08-23 4:41 PM JChristoff - 2007-08-23 3:52 PM The function MID would also work. Text = whatever cell Start = 1 Number=7 =MID(D4,1,7) The function has a lot more useability then LEFT, because you can pull from any point within the data Example: AH.0042.... you want 0042 Text = whatever cell Start = 3 Number = 4 =MID(D4,3,4) Lighten up, dude, it's not a competition...she asked a simple question, I gave her a simple answer....MID's great, so is RIGHT, & TRIM (LTRIM and RTRIM in SQL), etc. come in handy too...they wouldn't exist if they didn't serve a purpose...just saying.... Didn't see it as a competition and didn't mean to hit a nerve, sorry if it came across as rude... I was just giving another option for her problem. |
| 2007-08-27 12:20 PM in reply to: #941894 |
| Subject: ... This user's post has been ignored. |
| 2008-08-19 11:02 AM in reply to: #937984 |
| Pro 4827 Plano, Texas | Subject: RE: Need Excel Help From the past... AND something Excel related I learned today... =Ceiling(number, significance) I had a set of numbers that I wanted to always round up if the digit after the decimal was >0. This little command does it. |
| 2008-08-19 11:32 AM in reply to: #1613483 |
| Member 1699 | Subject: RE: Need Excel Help BTW, does anyone else find Microsoft's support pathetic? I cannot find anything on their website, yet there are plenty of forums or schlocky websites that are helpful for their products. It's not like they don't have the money to adequately support their products. |
| 2008-08-19 11:57 AM in reply to: #1613579 |
| Elite 2661 DC Metro, slowly working my way to NC | Subject: RE: Need Excel Help eberulf - 2008-08-19 12:32 PM BTW, does anyone else find Microsoft's support pathetic? I cannot find anything on their website, yet there are plenty of forums or schlocky websites that are helpful for their products. It's not like they don't have the money to adequately support their products. Yes. YES. Right now I'm having a problem with Excel 2007 crashing and I can't find jack about it on their website other than "be sure to be fully patched up!"... Fortunately I've gotten a couple potential solutions from other sites, but jeez, you're right, they do have enough $$ to be able to do some support. |
| 2008-08-19 1:11 PM in reply to: #937984 |
| Subject: RE: Need Excel Help By that standard, every software package I use is woefully undersupported. |
| 2008-08-19 2:05 PM in reply to: #938175 |
| Extreme Veteran 832 Podunk County, MN | Subject: RE: Need Excel Help kanders - 2007-08-23 3:26 PM Lara - 2007-08-23 2:26 PM Dude, that's not irony, that's coincidence. I really hate that when people do that. And btw, thanks for this example of using the left function. I'd forgotten about that handy little thing, and I've got something going that it's perfect for.LHablas - 2007-08-23 12:23 PM Yeah...in a new cell, use the formula: =LEFT(D4, 7), where D4 = your starting row... PERFECT!!! THANK YOU!!!! Ironicly D4 was the right cell/row... Boy did I sound like a cranky B in this post! Yikes! Sorry, Lara darling... |
| 2008-08-19 5:32 PM in reply to: #1614060 |
| Subject: ... This user's post has been ignored. |
| 2008-08-20 7:42 AM in reply to: #1613662 |
| Elite 3650 Laurium, MI | Subject: RE: Need Excel Help BodyCheck - 2008-08-19 12:57 PM eberulf - 2008-08-19 12:32 PM BTW, does anyone else find Microsoft's support pathetic? I cannot find anything on their website, yet there are plenty of forums or schlocky websites that are helpful for their products. It's not like they don't have the money to adequately support their products. Yes. YES. Right now I'm having a problem with Excel 2007 crashing and I can't find jack about it on their website other than "be sure to be fully patched up!"... Fortunately I've gotten a couple potential solutions from other sites, but jeez, you're right, they do have enough $$ to be able to do some support. that's the exact reason why I haven't touched excel (except long enough to export a xls file to csv) in YEARS. |
| 2008-08-20 8:11 AM in reply to: #941894 |
| Elite 2673 Muskego, WI | Subject: RE: Need Excel Help JChristoff - 2007-08-27 10:34 AM LHablas - 2007-08-23 4:41 PM Didn't see it as a competition and didn't mean to hit a nerve, sorry if it came across as rude... I was just giving another option for her problem.JChristoff - 2007-08-23 3:52 PM The function MID would also work. Text = whatever cell Start = 1 Number=7 =MID(D4,1,7) The function has a lot more useability then LEFT, because you can pull from any point within the data Example: AH.0042.... you want 0042 Text = whatever cell Start = 3 Number = 4 =MID(D4,3,4) Lighten up, dude, it's not a competition...she asked a simple question, I gave her a simple answer....MID's great, so is RIGHT, & TRIM (LTRIM and RTRIM in SQL), etc. come in handy too...they wouldn't exist if they didn't serve a purpose...just saying.... For the record, I appreciated both solutions, and their corresponding explanations. Thanks to both of you.
|
| 2008-08-21 8:29 AM in reply to: #937984 |
| Expert 1240 Columbia, MO | Subject: RE: Need Excel Help Another question
If I wanted a count of unique #'s in a list like above, what formula would I use to get it. The answer for the list should be 5 because there are 5 unique #'s |
| 2008-08-21 8:43 AM in reply to: #1618215 |
| Veteran 1097 Elizabethtown, KY | Subject: RE: Need Excel Help bsjracing - 2008-08-21 9:29 AM Another question
I had to research this myself several months back - here's the appropriate forumula (note, if the range includes alpha numeric values it needs to be tailored differently: =SUM(IF(FREQUENCY(The Range In Question, The Range in Question)>0,1)) Best of luck Edited by roch1009 2008-08-21 8:45 AM |
| 2008-08-21 8:47 AM in reply to: #937984 |
| Expert 1240 Columbia, MO | Subject: RE: Need Excel Help Some of the #'s have a last # of X will that change my formula requirements? as in 123456789X |
| 2008-08-21 8:52 AM in reply to: #1618215 |
| Pro 4827 Plano, Texas | Subject: RE: Need Excel Help bsjracing - 2008-08-21 8:29 AM Another question
Another way with more steps. 1. Sort the numbers. 2. In the column (column B) next to it =IF(A1=A2,"",1) This puts a one in the cell if the number does not equal the number below it. 3. At the bottom of column B, =count(b1:b9) I like the one step method (sum if frequency) better than this though. BT is so wonderful. I learn something new everyday.
Edited by KenD 2008-08-21 8:55 AM |
| 2008-08-21 8:58 AM in reply to: #1618252 |
| Veteran 1097 Elizabethtown, KY | Subject: RE: Need Excel Help bsjracing - 2008-08-21 9:47 AM Some of the #'s have a last # of X will that change my formula requirements? as in 123456789X It gets a little more complicated: =SUM(IF(FREQUENCY(MATCH(Range,Range,0),MATCH(Range,Range,0))>0,1)) Best of luck (oh, and you really don't want to know how long it took to find this out the first time) |
| 2008-08-21 8:58 AM in reply to: #1618266 |
| Expert 1240 Columbia, MO | Subject: RE: Need Excel Help The list has to be sorted by publisher first and then these #'s follow the publisher(they are individual serial #'s for books) |
|
|
|
|
View profile
Add to friends
Go to training log
Go to race log
Send a message
View album
CONNECT WITH FACEBOOK