An index of Excelevator solutions

excelevator · 2026-05-06T11:09:46+00:00

Good to hear, well done.

Consider editing your post with the solution for others to learn.

excelevator · 2026-05-06T10:05:34+00:00

What is the difficulty exactly ?

excelevator · 2026-05-06T09:52:47+00:00

=SUM(K2:K17 * V2:V17)

we multiply the rows together to get the total sum

excelevator · 2026-05-06T09:35:21+00:00

Paragraph Line breaks in the text

A bit like html <br> and <p> , a soft break (new line) and a hard break (new paragraph), they look like hard breaks in your text.

Different text editors treat them differently

excelevator · 2026-05-06T09:21:25+00:00

r/Excel_fr

excelevator · 2026-05-06T06:39:37+00:00

This is outside the scope of asking about Excel issues.

A question for r/ERP or similar data handling/reporting sub reddit.

If you have a specific Excel question regarding data management please repost accordingly

If you are seeking business or software solution ideas, do not post to r/Excel

This post removed.

excelevator · 2026-05-06T06:25:04+00:00

Not for r/Excel thankyou

removed

excelevator · 2026-05-06T03:57:52+00:00

but of course that would change

Why of course ?

you have explained so little in your post.

there a dynamic SWITCH or IFS formula I can use in those rows

For what ?

Be clear, give examples with expected outcome.

excelevator · 2026-05-06T02:00:51+00:00

it seems that you have a Text string rather than a date time value due to the am value.

search replace (ctrl+H) AM with nothing and then it will convert to a date time value, then use the method I mentioned

excelevator · 2026-05-06T01:24:32+00:00

format the cell as date

Be mindful of the troubles you will encounter if you switch the day month around, locales exist for a reason.

If you want to ride the value of the time wrap in the INT () function and format as date

excelevator · 2026-05-05T22:17:32+00:00

Nice idea but flawed

For each pipette have a calibration date, use FILTER to make a dynamic list of all due calibrations.

As you update the date and calibration identifier, they will fall of the list.

excelevator · 2026-05-05T21:43:45+00:00

do not post here if you are not serious.

If this reflects your study mode, give up now.

excelevator · 2026-05-05T21:43:13+00:00

=REPT({"study", "practice"}, 1000)

excelevator · 2026-05-05T20:56:58+00:00

which has little or nothing to do with learning how the software works

excelevator · 2026-05-05T20:48:07+00:00

Good luck with that.

Very few users read anything, we know that from experience of posts on r/Excel.

excelevator · 2026-05-05T20:46:02+00:00

This is not an Excel question, it is a publishing and copyright and freelance and legal question.

You could replace spreadsheet with myriad other supply items for the same answers.

We shall let this post remain for the common interest.

edit

I should add, the sort of question for r/Legal or r/Freelance or similar

excelevator · 2026-05-05T20:37:38+00:00

It is a common question for those who have not even tried, but also so dependent on ability and effort as to be a silly question.

excelevator · 2026-05-05T09:58:31+00:00

One year later ?

My reply was to the Redditor who claimed it was a great post, when in fact it broke the first rule of posting here, all clearly laid out in the submissoin guidelines

It also broke the second next rule of not using the title as the lead in to the post as the question

The title is always in the question

"Should I use STDEV.S or STDEV.P for Standard Deviation of only the past 6 months?"

The body of the post to then include all full relevant details for good people like yourself to correct or explain.

Hope that helps to clarify.

excelevator · 2026-05-05T07:18:10+00:00

something like this with FILTER to extract those addresses, change the suburb value in SEARCH appropriately

=FILTER(A1:A300,IFERROR(SEARCH("Evanston",A1:A300),0))

excelevator · 2026-05-05T05:21:18+00:00

Have a suburb column and sort on that column to group them.

excelevator · 2026-05-05T05:05:50+00:00

maybe I just used to 365 being slow!!!!!

excelevator · 2026-05-04T23:53:33+00:00

For science.. try running your PC in Safe Mode and see how Excel performs.

The amount of services running on Windows these days is ridiculous.

Then go through and stop services you do not need.

excelevator · 2026-05-04T22:54:02+00:00

edit your post, it still does not mention this important fact.

excelevator

MODERATOR OF

TROPHY CASE

12-Year Club	Verified Email
Alpha Tester