Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Help with creating a question - segment of age group

49 views
Skip to first unread message

Userme

unread,
May 9, 2022, 8:25:31 PM5/9/22
to
Hi
I have 2 tables like the one in this link/pictures (sorry for sending the link but hard to explain it)

https://www.timeatlas.com/wp-content/uploads/excel-segment-groups.jpg

So I want to ask a question to find the age of each voter and based on the age to find which age segment (young, mature, etc.) that voter belong to. Is this question fine? How you would write it yourself?
++++++++
Q) Find the age of each voter then use the lookup table (the small table) to find the segment based on that age?
++++++++

Thank you very much.

Peter T. Daniels

unread,
May 10, 2022, 10:45:26 AM5/10/22
to
Add a comma before "then"; no question mark after an imperative.

I don't know anything about Excel so I can't say anything about the content.
"Age group" rather than "age segment."

Userme

unread,
May 10, 2022, 2:06:49 PM5/10/22
to
Thank you very much for the help. I appreciate it.

spains...@gmail.com

unread,
May 11, 2022, 11:00:45 AM5/11/22
to
Your question relates to databases again. Follow Peter's instruction to rename
the "Segment" and "Label" columns to "Age group", and you have a Relational
Database with the Key Field being "Age group". Access would be able to link
them together, but you are using Excel - why not teach your students to do the
things only Excel can do?

A Cash Flow Forecast is the most obvious "spreadsheet-only" task.

Snidely

unread,
May 11, 2022, 10:15:25 PM5/11/22
to
On Wednesday or thereabouts, spains...@gmail.com declared ...
Ah, but a lot more businesses are run with Excel than with Access, and
Excel macros may make up 70% of programming in the world, with VB
getting to another 20%. These are rough estimates, but following
Dylan Beattie's talk at NDC Oslo 2021.

[naked ootoob link a.o.r]

/dps

--
"That's a good sort of hectic, innit?"

" Very much so, and I'd recommend the haggis wontons."
-njm

spains...@gmail.com

unread,
May 12, 2022, 9:17:57 AM5/12/22
to
Absolutely. But not the data lookup functions, surely? Excel is fantastic
and firing up a pivot table connected to a 3D ribbon chart, is nothing short
of miraculous. This family tree (which I have linked to before) is an Excel
macro:

https://www.youtube.com/watch?v=NOsLspFE2mQ

Bebercito

unread,
May 12, 2022, 11:05:12 AM5/12/22
to
Not exactly your query, but incidentally "New" isn't a relevant term for
an age group. Maybe "Youth" could be used instead, but that would
imply also renaming the "Young" group, which isn't easy in just one
word. Maybe just "Adult"?

>
> Thank you very much.
0 new messages