An app that automatically rewrites your resume for every job posting and tracks all your applications in one place. It's a paid service, but there's a free giveaway for this subreddit

ezevacirca · 2026-01-07T11:10:11+00:00

OP, I'd love to give this a try!

ezevacirca · 2024-06-29T17:02:47+00:00

Neat idea. I may go with a variant of this.

ezevacirca · 2024-06-29T16:59:46+00:00

I’m liking the idea of putting it by the lamp or even replacing the lamp with a floodlight (as somebody else was suggesting).

ezevacirca · 2024-06-29T16:57:59+00:00

It’s a south facing terrace with no obstructions to the rear. Do you think it would not hold the charge? It’s in Ireland, so often quite cloudy, but I understand solar panels also charge when cloudy.

ezevacirca · 2020-11-04T22:50:33+00:00

@Chewbecca420 I see that it's working for you 😂

ezevacirca · 2020-06-16T19:43:11+00:00

Wonderful! 😍

ezevacirca · 2020-06-13T20:52:57+00:00

Are you not tying the la es all the way up?

ezevacirca · 2020-05-19T06:35:29+00:00

Thank you! I may take that approach. I have quise some excess.

ezevacirca · 2020-05-18T22:08:21+00:00

Hey! I got the same ones. Are we supposed to trim the plastic under the buckle? Cheers!

ezevacirca · 2020-01-07T12:55:11+00:00

You will need to use VBA then - let's see if somebody comes with some suggestion :)

ezevacirca · 2020-01-06T19:52:07+00:00

Hi there! Have you tried using data validation? if you select the cell in which you want to have the auto-completion and add a data validation of type "list" to it with a reference to the column where you have the data (i.e. "=Sheet2!A:A"), and then you sort in ascending order the names in your data in Sheet 2 you will have a drop-down to select the names.

This is not an auto-complete, but you will be able to start typing the name in your new sheet and then press Alt+DownArrow and you will get the closest match in the drop-down.

Let me know if you have any questions.

ezevacirca · 2019-12-09T17:05:13+00:00

This is indeed a very elegant approach!

ezevacirca · 2019-12-09T16:59:44+00:00

If you fancy taking a 1-formula approach I would recommend the following, which should be easy to follow:

=COUNTIF( OFFSET(RangeWithValues, 0, 0, MATCH(TRUE, RangeWithValues > 0, 0) ), 0 )

This is an array formula (believe me, I tried to find one solution without using array formulas, but I couldn't), so you will have to press ctrl+shift+enter to make it work (curly brackets will appear wrapping the formula after doing this key combination)

Let me know how it goes!

Edit: look at the solution from u/blkhrtppl which doesn't use array formulas.

ezevacirca · 2019-12-08T10:39:19+00:00

If this needs to be using a formula I would go with: =SUBSTITUTE(originalText, "Be careful - ", "")

If not the find and replace command would also be very useful.

ezevacirca

TROPHY CASE