It would also aid members here or at Tek-Tips if you would upload a workable copy of any spreadsheet in question, because many of us would be ready to jump on a useable model of your problem an offer a workable solution or other alternatives for you evaluate directly.
Skip,
[glasses]Just...
I'd suggest starting to work on a design for your database before creating a spreadsheet or formal database. Get all your rules established regarding readings, estimates and billing and all your data identities identified and table relationships documented. You have already received many good...
You need NO KNOWLEDGE OF EXCEL FORMULAS to use the workbook I uploaded above. PASTE in 10,000 names if you like. The results are nearly instantaneous!
Skip,
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue]
I did a few modifications.
1) Inserted a Structured Table
2) Moved the New Assembly Name prefix above the table as well as 2 other pieces of data
So here's the drill. The data to Copy/Paste is on the Data sheet or you can use your own 2 columns of data.
1) Copy the 3 columns of data for new...
Unless your specifications are incorrect or incomplete, this could easily be accomplished if your table were a Structured Table (Insert > Tables > Table). I will send and example. Right now I'm not at my work station.
Procedural Steps
1. DELETE all but the FIRST ROW of DATA in the table. A...
How about a spreadsheet solution?
Added 3 columns in lt green
My results in lt blue
D3: =IF(LEFT(B3,8)="ASSEMBLY",RIGHT(B3,LEN(B3)-8),F2)
E3: =IF(ISBLANK(C3),"",IF(SUM(C2:C3)=1,65,IF(C3=E$2,E2+IF(OR(E2=72,E2=78),2,1),E2)))
F3...
Ken's got Excel questions.
Well "Engineering spreadsheets" not engineering, eh.
Ken, if they chase you away, check out https://www.tek-tips.com/threadminder.cfm?pid=68 the Tek-Tips sister site in the Microsoft Office Forum.
Skip,
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue]
Ken,
Is what you need is a template for
1) a list of teams,
2) number of games per team per week,
3) number of weeks
as input data?
Skip,
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue]
Check out self-winding wrist watches...
https://wristporn.com/blogs/news/what-is-a-self-winding-watch-complete-guide
Skip,
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue]
...AND if you are "tryna" do anything to make a positive impression on decision-makers, you have a high percentage chance being a "tryna" the rest of your life.
I consider myself fortunate, that in the last semester of my high school senior year, 64 years ago, Mrs. DeTurk drilled English...
1. For what purpose? Just a reference or to access data?
2. If the latter, is this tabular data or data in a discrete cell?
3. In order to suggest a method other than a hyperlink, I'd need to understand the what and why of this/these link(s).
4. I've created data acquisition methods to get...
"Correct info" is a list in the Compare sheet in column AS called Process List if I recall correctly.
Skip,
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue]
Well I'm gonna dissect your latest solution to learn something about the SMALL() function.
Thanks for posting your soultion.
Skip,
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue]
Ken, you've got a real mess on you hands when you're getting data from an external source that has columns in varying order and headings I presume. If it were me, I'd write VBA to standardize the column order at a minimum.
Since I don't understand the output requirements and the necessary...
Ken, I'm guessing you're balking at using Structured Tables.
The major reason is to keep the Name and Operation Name list references equivalent.
The second reason is self-documentation: that is usually column headings are somewhat descriptive and can be much more helpful within a formula as...
