Excel

Forum for posts that are not hockey-related.

Moderators: Three Stars, dagny, pfim, netwolf

Re: Excel

Postby Mr. Colby on Thu Feb 14, 2013 12:59 am

Juice wrote:I bet if we did a Vcardlookup of the posters in this thread true would get returned more than false boosh suck it nerds


:fist:
Mr. Colby
AHL Hall of Famer
AHL Hall of Famer
 
Posts: 8,302
Joined: Sun Dec 09, 2007 1:33 pm
Location: Born and Raised in Kent Manderville

Re: Excel

Postby Juice on Thu Feb 14, 2013 1:01 am

columbia wrote:
Juice wrote:I bet if we did a Vcardlookup of the posters in this thread true would get returned more than false boosh suck it nerds


This is why I load data into MySQL and just write queries.
Macros and Excel are for wusses.

I understand some of these words.
=Vcardlookup'columbia' returns "true"
Juice
AHL'er
AHL'er
 
Posts: 4,710
Joined: Wed Oct 25, 2006 10:23 pm
Location: Also I can crowbar.

Re: Excel

Postby mac5155 on Fri Mar 01, 2013 2:24 pm

Someone help me make a macro form that collects information but doesnt display it to everyone. I want to send out a shared excel sheet to collect personal info off people but can't let anyone see it. Info such as address, phone number, email address, etc.
mac5155
NHL Third Liner
NHL Third Liner
 
Posts: 47,212
Joined: Wed Dec 20, 2006 9:06 pm
Location: governor of Fayettenam

Re: Excel

Postby TheHammer24 on Fri Mar 01, 2013 3:17 pm

Vlookup is the way to go. But you can also just use "filter." That will bring a drop down box over the name of every column. Then you can just select only the zips you want, and only rows containing those zips will be displayed. Copy and Past the names out into a separate sheet.
TheHammer24
NHL Healthy Scratch
NHL Healthy Scratch
 
Posts: 13,992
Joined: Mon Nov 06, 2006 10:28 pm

Re: Excel

Postby mac5155 on Tue Jun 04, 2013 11:05 am

quick question.

I have a list of 2,500 numbers that are 7 digit. I want to count the occurances of each one and see what one is on there the most, least, and everywhere between.

Is it a Count-If function? I don't want to have to type in each individual number. There are probably 1500 different numbers on there 2500 times.
mac5155
NHL Third Liner
NHL Third Liner
 
Posts: 47,212
Joined: Wed Dec 20, 2006 9:06 pm
Location: governor of Fayettenam

Re: Excel

Postby mac5155 on Tue Jun 04, 2013 11:26 am

nvm, got it with a pivot table, duh.
mac5155
NHL Third Liner
NHL Third Liner
 
Posts: 47,212
Joined: Wed Dec 20, 2006 9:06 pm
Location: governor of Fayettenam

Re: Excel

Postby relantel on Tue Jun 04, 2013 12:21 pm

Try being the idiot that went row by row manually changing absolute cell references to another sheet to assemble a set of data sortable in another sheet without simply copying & pasting the data only. Considering the stat is dead and won't be added to, I didn't need to do that. But there has to be a way to do a realtive copy/paste and then convert to an absolute refernence without having to manually insert a pair of $$ in each cell.
relantel
NHL Fourth Liner
NHL Fourth Liner
 
Posts: 16,940
Joined: Sat Jan 28, 2006 11:24 am
Location: The card table

Re: Excel

Postby Letang Is The Truth on Tue Jun 04, 2013 12:57 pm

What were you trying to do?
Letang Is The Truth
NHL Fourth Liner
NHL Fourth Liner
 
Posts: 23,260
Joined: Fri Oct 31, 2008 2:59 pm
Location: The Panda Will Fly Away On A Rainbow

Re: Excel

Postby mac5155 on Tue Jun 04, 2013 1:10 pm

could do a merge cells right?
mac5155
NHL Third Liner
NHL Third Liner
 
Posts: 47,212
Joined: Wed Dec 20, 2006 9:06 pm
Location: governor of Fayettenam

Re: Excel

Postby relantel on Tue Jun 04, 2013 1:42 pm

Letang Is The Truth wrote:What were you trying to do?

had a sheet that aggregated data off of some 40+ other sheets unto a sum column, along with two text columns. Was pulling those three to a new sheet to sort independently in the new sheet without messing with the entry order (as the raw entries are largely grouped across the sheets - names rarely appear in more than 10 sheets).

Maybe what I was intending would work with relative references, but I've found absolute less error prone when sorting.
relantel
NHL Fourth Liner
NHL Fourth Liner
 
Posts: 16,940
Joined: Sat Jan 28, 2006 11:24 am
Location: The card table

Re: Excel

Postby ulf on Sun Jun 09, 2013 11:06 am

v-lookup?
ulf
NHL Healthy Scratch
NHL Healthy Scratch
 
Posts: 13,442
Joined: Wed Oct 03, 2007 4:41 pm

Re: Excel

Postby Letang Is The Truth on Thu Jun 27, 2013 4:43 pm

so i have an 07 document that populates with customer encounters. i thought i would be able to make it thru the fiscal year but i reached the row limit. its about 55 columns wide with some pretty sophisticated logic as well. is there an easy way to convert this to a 2010 document and increase the row limit?
Letang Is The Truth
NHL Fourth Liner
NHL Fourth Liner
 
Posts: 23,260
Joined: Fri Oct 31, 2008 2:59 pm
Location: The Panda Will Fly Away On A Rainbow

Re: Excel

Postby Beveridge on Thu Jun 27, 2013 4:46 pm

If I follow you, you should be able to just open the file in the 2010 version and continue.
Beveridge
AHL'er
AHL'er
 
Posts: 3,073
Joined: Mon Jun 25, 2012 3:38 pm

Re: Excel

Postby Letang Is The Truth on Thu Jun 27, 2013 4:53 pm

i tried that, it still keeps the finite number of rows
Letang Is The Truth
NHL Fourth Liner
NHL Fourth Liner
 
Posts: 23,260
Joined: Fri Oct 31, 2008 2:59 pm
Location: The Panda Will Fly Away On A Rainbow

Re: Excel

Postby ExPatriatePen on Thu Jun 27, 2013 6:39 pm

Letang Is The Truth wrote:so i have an 07 document that populates with customer encounters. i thought i would be able to make it thru the fiscal year but i reached the row limit. its about 55 columns wide with some pretty sophisticated logic as well. is there an easy way to convert this to a 2010 document and increase the row limit?

Are they individual customer encounters? Ie. one per customer experience?

Couldn't you just break it up with a tab for each month as an easy solution?
ExPatriatePen
NHL Fourth Liner
NHL Fourth Liner
 
Posts: 22,719
Joined: Sat Feb 04, 2006 3:57 pm
Location: Source, Destination, Protocol, Port, size, sequence number, check sum... Yep, that about covers it.

Re: Excel

Postby King Sid the Great 87 on Thu Jun 27, 2013 7:08 pm

Letang Is The Truth wrote:i tried that, it still keeps the finite number of rows


Did you do a save-as and change the format to 2010 and then re-open?
King Sid the Great 87
AHL'er
AHL'er
 
Posts: 2,934
Joined: Wed Jul 12, 2006 7:41 am

Re: Excel

Postby Letang Is The Truth on Thu Jun 27, 2013 8:19 pm

King Sid the Great 87 wrote:
Letang Is The Truth wrote:i tried that, it still keeps the finite number of rows


Did you do a save-as and change the format to 2010 and then re-open?


Yes, no dice :(
Letang Is The Truth
NHL Fourth Liner
NHL Fourth Liner
 
Posts: 23,260
Joined: Fri Oct 31, 2008 2:59 pm
Location: The Panda Will Fly Away On A Rainbow

Re: Excel

Postby Letang Is The Truth on Thu Jun 27, 2013 8:21 pm

ExPatriatePen wrote:
Letang Is The Truth wrote:so i have an 07 document that populates with customer encounters. i thought i would be able to make it thru the fiscal year but i reached the row limit. its about 55 columns wide with some pretty sophisticated logic as well. is there an easy way to convert this to a 2010 document and increase the row limit?

Are they individual customer encounters? Ie. one per customer experience?

Couldn't you just break it up with a tab for each month as an easy solution?


Yes however we have a several pivot tables worth of data that draw their info from this sheet. Is the source data changeable so that you can have it cover multiple tabs?
Letang Is The Truth
NHL Fourth Liner
NHL Fourth Liner
 
Posts: 23,260
Joined: Fri Oct 31, 2008 2:59 pm
Location: The Panda Will Fly Away On A Rainbow

Re: Excel

Postby ulf on Thu Jun 27, 2013 9:40 pm

v lookup?
ulf
NHL Healthy Scratch
NHL Healthy Scratch
 
Posts: 13,442
Joined: Wed Oct 03, 2007 4:41 pm

Previous

Return to NHR

Who is online

Users browsing this forum: CERV96, Eismann, Jim and 7 guests

e-mail