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 All-Star
AHL All-Star
 
Posts: 6,724
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,318
Joined: Wed Oct 25, 2006 10:23 pm
Location: Tag Bueno.

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: 42,152
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,038
Joined: Mon Nov 06, 2006 10:28 pm

Previous

Return to NHR

Who is online

Users browsing this forum: Bioshock, CERV96, FreeCandy44, Idoit40fans and 10 guests

e-mail