ASP Free Lounge
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free Forums > Other > ASP Free Lounge
Reload this Page

Page 2 - Excel help required

Page 2 - Discuss Excel help required in the ASP Free Lounge forum on ASP Free.
Excel help required ASP development forum discussing anything that doesn't fit into the other forums. This is the place to relax, talk, and maybe even have some friendly debate.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Page 2 of 2 < 1 2
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #16  
Old September 1st, 2005, 03:53 PM
freeasphelp's Avatar
freeasphelp freeasphelp is offline
Beyond The Impossible
ASP Free Novice (500 - 999 posts)
  
Join Date: Sep 2003
Location: Shawnee Mission, KS, USA
Posts: 921 freeasphelp User rank is Corporal (100 - 500 Reputation Level)freeasphelp User rank is Corporal (100 - 500 Reputation Level)freeasphelp User rank is Corporal (100 - 500 Reputation Level)freeasphelp User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 4 Days 23 h 25 m 9 sec
Reputation Power: 7
__________________
John Shepard
Beyond The Impossible
-----------------------------
Has a post helped you? Please show your apprecitation by clicking the
image in the right upper corner.
Posting code? Put your code between [code] and [/code] tags.
X-Login and X-Send
Reply With Quote
  #17  
Old September 1st, 2005, 03:54 PM
Black&White's Avatar
Black&White Black&White is offline
Play up Pompey!
ASP Free Beginner (1000 - 1499 posts)
  
Join Date: Feb 2005
Location: Hampshire, ENG
Posts: 1,100 Black&White User rank is Second Lieutenant (5000 - 10000 Reputation Level)Black&White User rank is Second Lieutenant (5000 - 10000 Reputation Level)Black&White User rank is Second Lieutenant (5000 - 10000 Reputation Level)Black&White User rank is Second Lieutenant (5000 - 10000 Reputation Level)Black&White User rank is Second Lieutenant (5000 - 10000 Reputation Level)Black&White User rank is Second Lieutenant (5000 - 10000 Reputation Level)Black&White User rank is Second Lieutenant (5000 - 10000 Reputation Level)  Folding Points: 9032 Folding Title: Novice Folder
Time spent in forums: 1 Week 1 Day 22 h 26 m 43 sec
Reputation Power: 62
Quote:
Originally Posted by freeasphelp


ooh, sounds good, I hope there isn't a Mrs. Excel
Reply With Quote
  #18  
Old September 1st, 2005, 04:06 PM
RadioactiveFrog's Avatar
RadioactiveFrog RadioactiveFrog is offline
Senior Glowing Wizard
ASP Free God 7th Plane (8000 - 8499 posts)
  
Join Date: May 2005
Location: Sussex
Posts: 8,223 RadioactiveFrog User rank is Major (30000 - 40000 Reputation Level)RadioactiveFrog User rank is Major (30000 - 40000 Reputation Level)RadioactiveFrog User rank is Major (30000 - 40000 Reputation Level)RadioactiveFrog User rank is Major (30000 - 40000 Reputation Level)RadioactiveFrog User rank is Major (30000 - 40000 Reputation Level)RadioactiveFrog User rank is Major (30000 - 40000 Reputation Level)RadioactiveFrog User rank is Major (30000 - 40000 Reputation Level)RadioactiveFrog User rank is Major (30000 - 40000 Reputation Level)RadioactiveFrog User rank is Major (30000 - 40000 Reputation Level)RadioactiveFrog User rank is Major (30000 - 40000 Reputation Level)  Folding Points: 160711 Folding Title: Super Ultimate Folder - Level 1Folding Points: 160711 Folding Title: Super Ultimate Folder - Level 1Folding Points: 160711 Folding Title: Super Ultimate Folder - Level 1Folding Points: 160711 Folding Title: Super Ultimate Folder - Level 1Folding Points: 160711 Folding Title: Super Ultimate Folder - Level 1Folding Points: 160711 Folding Title: Super Ultimate Folder - Level 1
Time spent in forums: 3 Weeks 4 Days 3 h 46 m 30 sec
Reputation Power: 326
Send a message via MSN to RadioactiveFrog
Facebook
Quote:
Originally Posted by Black&White
ooh, sounds good, I hope there isn't a Mrs. Excel
why do you prefer the guys
Reply With Quote
  #19  
Old September 1st, 2005, 04:23 PM
Black&White's Avatar
Black&White Black&White is offline
Play up Pompey!
ASP Free Beginner (1000 - 1499 posts)
  
Join Date: Feb 2005
Location: Hampshire, ENG
Posts: 1,100 Black&White User rank is Second Lieutenant (5000 - 10000 Reputation Level)Black&White User rank is Second Lieutenant (5000 - 10000 Reputation Level)Black&White User rank is Second Lieutenant (5000 - 10000 Reputation Level)Black&White User rank is Second Lieutenant (5000 - 10000 Reputation Level)Black&White User rank is Second Lieutenant (5000 - 10000 Reputation Level)Black&White User rank is Second Lieutenant (5000 - 10000 Reputation Level)Black&White User rank is Second Lieutenant (5000 - 10000 Reputation Level)  Folding Points: 9032 Folding Title: Novice Folder
Time spent in forums: 1 Week 1 Day 22 h 26 m 43 sec
Reputation Power: 62
Quote:
Originally Posted by RadioactiveFrog
why do you prefer the guys


can't help it if the guys like to follow me around, take you for example
Reply With Quote
  #20  
Old September 1st, 2005, 05:47 PM
RadioactiveFrog's Avatar
RadioactiveFrog RadioactiveFrog is offline
Senior Glowing Wizard
ASP Free God 7th Plane (8000 - 8499 posts)
  
Join Date: May 2005
Location: Sussex
Posts: 8,223 RadioactiveFrog User rank is Major (30000 - 40000 Reputation Level)RadioactiveFrog User rank is Major (30000 - 40000 Reputation Level)RadioactiveFrog User rank is Major (30000 - 40000 Reputation Level)RadioactiveFrog User rank is Major (30000 - 40000 Reputation Level)RadioactiveFrog User rank is Major (30000 - 40000 Reputation Level)RadioactiveFrog User rank is Major (30000 - 40000 Reputation Level)RadioactiveFrog User rank is Major (30000 - 40000 Reputation Level)RadioactiveFrog User rank is Major (30000 - 40000 Reputation Level)RadioactiveFrog User rank is Major (30000 - 40000 Reputation Level)RadioactiveFrog User rank is Major (30000 - 40000 Reputation Level)  Folding Points: 160711 Folding Title: Super Ultimate Folder - Level 1Folding Points: 160711 Folding Title: Super Ultimate Folder - Level 1Folding Points: 160711 Folding Title: Super Ultimate Folder - Level 1Folding Points: 160711 Folding Title: Super Ultimate Folder - Level 1Folding Points: 160711 Folding Title: Super Ultimate Folder - Level 1Folding Points: 160711 Folding Title: Super Ultimate Folder - Level 1
Time spent in forums: 3 Weeks 4 Days 3 h 46 m 30 sec
Reputation Power: 326
Send a message via MSN to RadioactiveFrog
Facebook
Quote:
Originally Posted by Black&White
can't help it if the guys like to follow me around, take you for example
i think you were following me!! After all i was typing the fastest
Reply With Quote
  #21  
Old September 5th, 2005, 03:55 AM
roughneck82 roughneck82 is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Oct 2004
Location: Tejas
Posts: 63 roughneck82 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 6 h 32 m 5 sec
Reputation Power: 5
Quote:
Originally Posted by Black&White
I was just wondering if this was possible and the example I'll show is much smaller scale than what I'd like to do.

Circled in red is data posted into the spreadsheet from an outside source.
Circled in blue is a permanent table which shows each name and from the pasted data calculates the improvement.

The names circled in blue are fixed and never change.
The names circled in red could potentially change order each time it is pasted.

Thats where the problem comes in. It would be simple if each of the names in the red circle were fixed too but their not. As the names change position frequently I was wondering if it were somehow possible to match the names in blue circle with the names in the red circle. Thus making it possible to use the data in the red circle to change the values in the blue circle.



Hopefully someone understood all the red circle/blue circle nonsense. I don't care if its not possible but I would like to know and if is possible I'd like to know how :P

Thanks,
B&W


If you're still wondering, I'd do a Vlookup from another sheet
Reply With Quote
  #22  
Old September 5th, 2005, 04:53 AM
Black&White's Avatar
Black&White Black&White is offline
Play up Pompey!
ASP Free Beginner (1000 - 1499 posts)
  
Join Date: Feb 2005
Location: Hampshire, ENG
Posts: 1,100 Black&White User rank is Second Lieutenant (5000 - 10000 Reputation Level)Black&White User rank is Second Lieutenant (5000 - 10000 Reputation Level)Black&White User rank is Second Lieutenant (5000 - 10000 Reputation Level)Black&White User rank is Second Lieutenant (5000 - 10000 Reputation Level)Black&White User rank is Second Lieutenant (5000 - 10000 Reputation Level)Black&White User rank is Second Lieutenant (5000 - 10000 Reputation Level)Black&White User rank is Second Lieutenant (5000 - 10000 Reputation Level)  Folding Points: 9032 Folding Title: Novice Folder
Time spent in forums: 1 Week 1 Day 22 h 26 m 43 sec
Reputation Power: 62
yeah sorry, forgot to mention, problem solved thanks to Mr Excel
Reply With Quote
  #23  
Old September 5th, 2005, 05:03 AM
Megster Megster is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Jul 2005
Location: Scotland.
Posts: 465 Megster User rank is Corporal (100 - 500 Reputation Level)Megster User rank is Corporal (100 - 500 Reputation Level)Megster User rank is Corporal (100 - 500 Reputation Level)Megster User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 2 Days 22 h 53 m 38 sec
Reputation Power: 7
Quote:
Originally Posted by Black&White
ooh, sounds good, I hope there isn't a Mrs. Excel



why's everyone so anti-woman??? lol
Reply With Quote
Reply
Page 2 of 2 < 1 2

Viewing: ASP Free Forums > Other > ASP Free Lounge > Excel help required

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This 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
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump



 Free IT White Papers!
 
How to Present Effectively Online
This white paper offers practical and actionable advice on the key steps that any presenter should consider as they plan and execute a Webinar or online meeting.
 
Open Source Security Myths
Open Source Software (OSS) is computer software whose source code is available to the general public with relaxed or non-existent intellectual property restrictions (or arrangement such as the public domain), and is usually developed with the input of many contributors.
 
Power and Cooling Capacity Management for Data Centers
This paper describes the principles for achieving power and cooling capacity management.
 
Scalable, Fault-Tolerant NAS for Oracle - The Next Generation
For several years NAS has been evolving as a storage alternative for Oracle databases, and for good reason: NAS is quite often the simplest, most cost-effective storage approach for Oracle. Learn about the benefits that HP's approach to scalable NAS brings to Oracle environments in this comprehensive white paper.
 
Understanding Web Application Security Challenges
This white paper discusses many common threats and preventive measures for Web application security, and explains what you can do to help protect your organization.
 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2009 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway. 
Stay green...Green IT