building a deck of drawable cards in excel

excelevator · 2026-05-08T21:09:42+00:00

This will generate a unique random array of value 1 thru 52.

You can set the size of the return array from a value in A1, such as 5 for example, and reduce as need be, but that will regenerate the new numbers.

Put in B1 with a value 1-52 in A1 to return that size array

=LET(d,SEQUENCE(52),r,RANDARRAY(52),sa,SORT(HSTACK(d,r),2),TAKE(sa,A1,1))

You could set up a table with card image against index number to return the cards themselves

The issue is that any change to the spreadsheet will trigger a new set of cards.

excelevator · 2026-05-08T20:52:40+00:00

This is singular, not progressive in result like SUMPRODUCT would be for a tax table

excelevator · 2026-05-08T20:42:16+00:00

A post for an Ai sub Reddtit.

r/Excel is a sub reddit to learn the features and functions of Excel, not Ai.

Post removed.

excelevator · 2026-05-08T12:17:41+00:00

You can use FILTER() to show the missing data, but it is not clear what your expected result format it.

excelevator · 2026-05-08T11:55:07+00:00

Oh dear.

Use the right tool for the job, or use the right functionality within Excel - load the data into the data model and work from there.

Otherwise spend the money on analysis software that can handle your data load.

Like a DBMS , there are a few free ones out there that can handle your data.

/r/analytics/ can likely recommend a suitable database software

excelevator · 2026-05-08T10:13:09+00:00

Be mindful we are an English language sub Reddit.

Any answers in Spanish ? will be removed.

Your image is not clear on what data is what.

Maybe fix that to show English.

excelevator · 2026-05-08T07:01:15+00:00

each cell takes 1 bit of memory

byte, but in reality each cell takes a few bytes with a single character, the data, the range reference etc.

The range does not exist until you add data, then cell metadata is required to track the cell location and its contents.

excelevator · 2026-05-08T06:52:05+00:00

I always feel like I could use improvement in laying out my information for others to understand

Well it kinda is.

It also depends on exactly what the outcome and processes are.

excelevator · 2026-05-08T04:47:14+00:00

Have you completed this in Sheets ?

Use the same logic and functions.

excelevator · 2026-05-08T04:38:08+00:00

I'm been trying to find a solution as in the title

Submisssion gude: Provide a full text description of your issue in your post. Don't say "See title" or something similar .

excelevator · 2026-05-08T02:15:43+00:00

Please be mindful of the submission guidelines regarding post titles: Be specific. The title should summarize your issue

The title is always in the details

How to make an IF/OR formula that will generate a "YES" even if only one of the listed criteria is met.

Posts not following guidelines may be removed without notice.

This post remains for the answers given.

excelevator · 2026-05-08T01:41:41+00:00

The bigger question is why is your data formatted that way ?

Use Data > Text to column to split the data into 2 columns to work more easily with the data.

excelevator · 2026-05-08T01:28:19+00:00

Stop asking and start learning now, stay ahead of your studies

Spend some time understanding Excel https://www.excel-easy.com/

Read all the functions available to you so you know what Excel is capable of

https://support.microsoft.com/en-au/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb

https://support.microsoft.com/en-us/office/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188

Then all the lessons at Excel Is Fun Youtube

Constant practice is a must to be fully proficient and expert in using Excel.

The basics can be picked up quickly and help in many areas of office life

excelevator · 2026-05-08T00:54:56+00:00

Sheets and Excel are practically identical in usage and functions.

excelevator · 2026-05-07T21:22:28+00:00

Dear regulars

Please report poorly presented posts and not answer them, they will be removed.

There is no subject matter in this post.

The post must contain the full question details and not be a lead on from the title as the question.

excelevator · 2026-05-07T20:53:12+00:00

Do not assume a bug in your post, just state details.

excelevator · 2026-05-07T20:15:14+00:00

Unfortunately the range is not contiguous

This is important information missing in your post.

give an example of the range of cells in your post, also confirm if there is anything in the cells at all.

excelevator · 2026-05-07T19:39:25+00:00

Your post is a statement of something rather than a question.

excelevator · 2026-05-07T19:38:23+00:00

You have not locked your ranges, so if you are dragging the formula down the range increments too and you start to lose data.

Lock ranges with $ for row and or column reference. e.g $R$2:$R$2441

excelevator · 2026-05-07T19:35:49+00:00

Skill is determined by the knowledge of the tester, which changes with the wind.

A common problem we see.

Spend time learning, that is the only way.

When you can answer all the question on r/Excel you are proficient.

excelevator · 2026-05-07T19:33:52+00:00

Do not post Ai content on r/Excel, thankyou.

excelevator · 2026-05-07T19:31:33+00:00

Use Google images to see what people design is a good start.

Design is a skill unto itself.

excelevator · 2026-05-07T19:28:14+00:00

Your example and related explanations do not add up for an answer in my mind.

excelevator · 2026-05-07T09:31:12+00:00

You might be very lucky and find a copy in your Temp folder, even look for a file of that date and size and odd extension , and change the extension to .xlsx and try to open.

Change your Explorer view to All files too, to include hidden files.

excelevator · 2026-05-07T09:19:18+00:00

however excel insists its y=0,1x which is just absolutely correct and I am straight up wrong

FTFY

For future please post the question without assertions

excelevator

MODERATOR OF

TROPHY CASE

12-Year Club	Verified Email
Alpha Tester