Home Discord Chat
Go Back   ChiefsPlanet > Nzoner's Game Room
Reload this Page Computers Microsoft Excel - How often do you use it?
Register FAQDonate Members List Calendar

Reply
Page 7 of 8 « First 3456 7 8
 
Thread Tools Display Modes
Old 12-08-2018, 03:09 PM  
Coach Coach is offline
Champs!
 
Coach's Avatar
 
Join Date: Mar 2004
Location: Kansas City
Casino cash: $5938476
Microsoft Excel - How often do you use it?
For advanced users, tell us some of your tricks in terms of using the formulas and such.

For beginners, ask questions here, hopefully answers could be provided.

As for me, my question to the experts/advanced users,

Let's say if I have a spreadsheet with column A that has names, typically last name, first name and middle initial (example: Smith, Joe Steve). Column B has names that is typically the same as column A, except it would be missing the middle name or a misspelling on the first name (example: Smith, Joe).


Column A would have say 450 names and Column B would have 150. How can a "near" match search be found, after utilizing the conditional formatting that highlights duplicate values?
Posts: 53,212
Coach is obviously part of the inner Circle.Coach is obviously part of the inner Circle.Coach is obviously part of the inner Circle.Coach is obviously part of the inner Circle.Coach is obviously part of the inner Circle.Coach is obviously part of the inner Circle.Coach is obviously part of the inner Circle.Coach is obviously part of the inner Circle.Coach is obviously part of the inner Circle.Coach is obviously part of the inner Circle.Coach is obviously part of the inner Circle.
     Reply With Quote
Old 07-08-2019, 11:21 AM   #91
Mr. Plow Mr. Plow is offline
In Search of a Life
 
Mr. Plow's Avatar
 

Join Date: Dec 2005
Casino cash: $1967391
Quote:
Originally Posted by loochy View Post

It seems like 7 different pivot tables inserted on new sheets would do what you want.

Or you could just use a filter and do 7 copy and pastes? This seems too simple...maybe I don't fully understand your request.
I was thinking too big........ but your msg just cleared my head. Damnit.


I was over complicating a simple problem.
Posts: 30,809
Mr. Plow is obviously part of the inner Circle.Mr. Plow is obviously part of the inner Circle.Mr. Plow is obviously part of the inner Circle.Mr. Plow is obviously part of the inner Circle.Mr. Plow is obviously part of the inner Circle.Mr. Plow is obviously part of the inner Circle.Mr. Plow is obviously part of the inner Circle.Mr. Plow is obviously part of the inner Circle.Mr. Plow is obviously part of the inner Circle.Mr. Plow is obviously part of the inner Circle.Mr. Plow is obviously part of the inner Circle.
     Reply With Quote
Old 07-08-2019, 11:29 AM   #92
Mr. Plow Mr. Plow is offline
In Search of a Life
 
Mr. Plow's Avatar
 

Join Date: Dec 2005
Casino cash: $1967391
Damn I'm an idiot. Done with the breakout in 3 minutes after staring at it for 20.
Posts: 30,809
Mr. Plow is obviously part of the inner Circle.Mr. Plow is obviously part of the inner Circle.Mr. Plow is obviously part of the inner Circle.Mr. Plow is obviously part of the inner Circle.Mr. Plow is obviously part of the inner Circle.Mr. Plow is obviously part of the inner Circle.Mr. Plow is obviously part of the inner Circle.Mr. Plow is obviously part of the inner Circle.Mr. Plow is obviously part of the inner Circle.Mr. Plow is obviously part of the inner Circle.Mr. Plow is obviously part of the inner Circle.
     Reply With Quote
Old 10-29-2021, 11:18 AM   #93
ModSocks ModSocks is online now
Needs more middle fingers
 
ModSocks's Avatar
 

Join Date: Mar 2005
Location: San Diego
Casino cash: $4274563
Damn, im drawing a blank on this one, feel like i should know it.

Question:

Lets say i have a date field in a specific cell and want that same date to auto fill in another cell.

Basically, i have the date on the top of the page and don't want to have to manually rewrite the date on each corresponding page within my worksheet. How do i do that? TIA.
__________________
Life is like a dick. Sometimes it gets hard for no reason, but it can't stay hard forever.
Posts: 64,342
ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.
     Reply With Quote
Old 10-29-2021, 11:24 AM   #94
duncan_idaho duncan_idaho is online now
M-I-Z-Z-O-U
 
duncan_idaho's Avatar
 

Join Date: Apr 2001
Location: Kansas City
Casino cash: $1730308
Quote:
Originally Posted by Detoxing View Post
Damn, im drawing a blank on this one, feel like i should know it.

Question:

Lets say i have a date field in a specific cell and want that same date to auto fill in another cell.

Basically, i have the date on the top of the page and don't want to have to manually rewrite the date on each corresponding page within my worksheet. How do i do that? TIA.
Don't know an automated trick for that without running into VBA. How many sheets are you talking?

Is it too many to do a simple =[CELL] and make the cell reference absolute, then copy and paste that cell on each sheet?
__________________
"You gotta love livin', cause dying is a pain in the ass."
---- Sinatra
Posts: 21,102
duncan_idaho is obviously part of the inner Circle.duncan_idaho is obviously part of the inner Circle.duncan_idaho is obviously part of the inner Circle.duncan_idaho is obviously part of the inner Circle.duncan_idaho is obviously part of the inner Circle.duncan_idaho is obviously part of the inner Circle.duncan_idaho is obviously part of the inner Circle.duncan_idaho is obviously part of the inner Circle.duncan_idaho is obviously part of the inner Circle.duncan_idaho is obviously part of the inner Circle.duncan_idaho is obviously part of the inner Circle.
     Reply With Quote
Old 10-29-2021, 11:40 AM   #95
MMXcalibur MMXcalibur is offline
Pessimistically optimistic.
 
MMXcalibur's Avatar
 

Join Date: Jan 2009
Location: Denver, CO
Casino cash: $2425086
Quote:
Originally Posted by duncan_idaho View Post
Don't know an automated trick for that without running into VBA. How many sheets are you talking?

Is it too many to do a simple =[CELL] and make the cell reference absolute, then copy and paste that cell on each sheet?
I am managing my online EA leagues using Excel and learning quite a bit. Learned about absolute references too. =$A$1 will make it so you can copy/paste and the pasted entries won't auto-change.
Posts: 16,418
MMXcalibur is obviously part of the inner Circle.MMXcalibur is obviously part of the inner Circle.MMXcalibur is obviously part of the inner Circle.MMXcalibur is obviously part of the inner Circle.MMXcalibur is obviously part of the inner Circle.MMXcalibur is obviously part of the inner Circle.MMXcalibur is obviously part of the inner Circle.MMXcalibur is obviously part of the inner Circle.MMXcalibur is obviously part of the inner Circle.MMXcalibur is obviously part of the inner Circle.MMXcalibur is obviously part of the inner Circle.
     Reply With Quote
Old 10-29-2021, 12:52 PM   #96
eDave eDave is offline
Banned
 

Join Date: Jan 2013
Casino cash: $9998560
= your subsequent page date cells to the original? If it changes daily, =(dated cell)+1.


Idaho explained it better
Posts: 53,803
eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.
     Reply With Quote
Old 10-29-2021, 01:04 PM   #97
ModSocks ModSocks is online now
Needs more middle fingers
 
ModSocks's Avatar
 

Join Date: Mar 2005
Location: San Diego
Casino cash: $4274563
Quote:
Originally Posted by duncan_idaho View Post
Don't know an automated trick for that without running into VBA. How many sheets are you talking?

Is it too many to do a simple =[CELL] and make the cell reference absolute, then copy and paste that cell on each sheet?
Quote:
Originally Posted by eDave View Post
= your subsequent page date cells to the original? If it changes daily, =(dated cell)+1.


Idaho explained it better
Hrmm...i'm not following.

Here's what im doing:

I've created a daily task sheet via excel. A universal sheet for all the guys in the shop to work off of, that they can access as a shared document via OneDrive.

I've laid it out so that i can fit 15 tasks in a single printable 8.5x11 sheet. However, somedays we may have more than 15 tasks, thus it would turn into a 2nd printable sheet.

I don't want to have to re-write the date for each printable sheet. I want to enter it once on page 1, and then each subsequent page the data in that cell (B3) replicates on my 2nd, 3rd, 4th page etc. w/o having to re enter each time. Because i won't, i'll end up forgetting to change the date on each page knowing me.
__________________
Life is like a dick. Sometimes it gets hard for no reason, but it can't stay hard forever.
Posts: 64,342
ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.
     Reply With Quote
Old 10-29-2021, 01:13 PM   #98
kccrow kccrow is offline
MVP
 
kccrow's Avatar
 

Join Date: Oct 2011
Location: Michigan
Casino cash: $3217078
You should use Print functions for what you want in my opinion. In Excel you can select Rows to repeat at the top of each page. Create a header in row 1 of your sheet with the date in it and repeat it. Go to Page Layout Tab and then to Print Titles where you'll see "rows to repeat at top"
Posts: 12,660
kccrow 's phone was tapped by Scott Pioli.kccrow 's phone was tapped by Scott Pioli.kccrow 's phone was tapped by Scott Pioli.kccrow 's phone was tapped by Scott Pioli.kccrow 's phone was tapped by Scott Pioli.kccrow 's phone was tapped by Scott Pioli.kccrow 's phone was tapped by Scott Pioli.kccrow 's phone was tapped by Scott Pioli.kccrow 's phone was tapped by Scott Pioli.kccrow 's phone was tapped by Scott Pioli.kccrow 's phone was tapped by Scott Pioli.
 Thumbs Up 1 Thumbs Down 0     Reply With Quote
Old 10-29-2021, 01:23 PM   #99
eDave eDave is offline
Banned
 

Join Date: Jan 2013
Casino cash: $9998560
Quote:
Originally Posted by Detoxing View Post
Hrmm...i'm not following.

Here's what im doing:

I've created a daily task sheet via excel. A universal sheet for all the guys in the shop to work off of, that they can access as a shared document via OneDrive.

I've laid it out so that i can fit 15 tasks in a single printable 8.5x11 sheet. However, somedays we may have more than 15 tasks, thus it would turn into a 2nd printable sheet.

I don't want to have to re-write the date for each printable sheet. I want to enter it once on page 1, and then each subsequent page the data in that cell (B3) replicates on my 2nd, 3rd, 4th page etc. w/o having to re enter each time. Because i won't, i'll end up forgetting to change the date on each page knowing me.




Or convert it to Word and use the date function in the footer or header.
Posts: 53,803
eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.
     Reply With Quote
Old 10-29-2021, 01:42 PM   #100
Rain Man Rain Man is offline
NFL's #1 Ermines Fan
 
Rain Man's Avatar
 

Join Date: Jul 2001
Location: My house
Casino cash: $3298491
VARSITY
Quote:
Originally Posted by eDave View Post



Or convert it to Word and use the date function in the footer or header.

Yep.
__________________
I'm putting random letters here as a celebration of free speech: xigrakgrah misorojeq rkemeseit.
Posts: 141,448
Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.
 Thumbs Up 1 Thumbs Down 0     Reply With Quote
Old 10-29-2021, 01:43 PM   #101
ModSocks ModSocks is online now
Needs more middle fingers
 
ModSocks's Avatar
 

Join Date: Mar 2005
Location: San Diego
Casino cash: $4274563
Quote:
Originally Posted by eDave View Post



Or convert it to Word and use the date function in the footer or header.
Tried the (Sheet1!B3) and it just gave me a #ref error. Could it because B3 is merged with B4 and B5?
__________________
Life is like a dick. Sometimes it gets hard for no reason, but it can't stay hard forever.
Posts: 64,342
ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.
     Reply With Quote
Old 10-29-2021, 01:46 PM   #102
eDave eDave is offline
Banned
 

Join Date: Jan 2013
Casino cash: $9998560
Quote:
Originally Posted by Detoxing View Post
Tried the (Sheet1!B3) and it just gave me a #ref error. Could it because B3 is merged with B4 and B5?
I'd assume so. Unmerge and try again.
Posts: 53,803
eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.
     Reply With Quote
Old 10-29-2021, 01:50 PM   #103
ModSocks ModSocks is online now
Needs more middle fingers
 
ModSocks's Avatar
 

Join Date: Mar 2005
Location: San Diego
Casino cash: $4274563
Un merged still no go. IDK wtf is going on. Your solution is the solution i found online and still #ref!

Bah. Frustrating.

Edit: B3 is actually merged with C3, D3.

Not that that should matter. I un-merged them and still no go.
__________________
Life is like a dick. Sometimes it gets hard for no reason, but it can't stay hard forever.
Posts: 64,342
ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.
     Reply With Quote
Old 10-29-2021, 01:57 PM   #104
eDave eDave is offline
Banned
 

Join Date: Jan 2013
Casino cash: $9998560
Quote:
Originally Posted by Detoxing View Post
Un merged still no go. IDK wtf is going on. Your solution is the solution i found online and still #ref!

Bah. Frustrating.

Edit: B3 is actually merged with C3, D3.

Not that that should matter. I un-merged them and still no go.
The formula I provided assumes the cells are on different tabs. I think I misunderstood what you are trying to do. You want the 2nd printed page to add the date if it runs to a second page printing. For that I just know when to start a new tab based on print area. If you are trying this on the same tab then it's just =A3. No sheet reference. It's ref erroring because of the external sheet reference is the same tab.
Last edited by eDave; 10-29-2021 at 02:49 PM..
Posts: 53,803
eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.eDave is obviously part of the inner Circle.
 Thumbs Up 1 Thumbs Down 0     Reply With Quote
Old 10-29-2021, 02:00 PM   #105
ModSocks ModSocks is online now
Needs more middle fingers
 
ModSocks's Avatar
 

Join Date: Mar 2005
Location: San Diego
Casino cash: $4274563
Quote:
Originally Posted by eDave View Post
The formula I provided assumes the cells are on different tabs. I think I misunderstood what you are trying to do. You want the 2nd printed page to add the date if it runs to a second page printing. For that I just know when to start a new tab based on print area. If you are trying this on the same tab then it's just =A3. No sheet reference.


That fixed it. Thanks.

God i feel so stupid right now. I knew it was going to be something so simple.
__________________
Life is like a dick. Sometimes it gets hard for no reason, but it can't stay hard forever.
Posts: 64,342
ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.ModSocks is obviously part of the inner Circle.
 Thumbs Up 1 Thumbs Down 0     Reply With Quote
Reply
Page 7 of 8 « First 3456 7 8

« Previous Thread | > Nzoner's Game Room < | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump




All times are GMT -6. The time now is 10:14 AM.

Contact Us - ChiefsPlanet - Archive - Top

This is a test for a client's site.
Fort Worth Texas Process Servers
Covering Arlington, Fort Worth, Grand Prairie and surrounding communities.
Tarrant County, Texas and Johnson County, Texas.
Advertise with us!
Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2024, vBulletin Solutions, Inc.