Avatar billede Nuser2008 Mester
09. oktober 2024 - 15:54 Der er 2 kommentarer og
1 løsning

Find empty cell between cells with value

Hi Forum,

I hope you can help me out here :-). I'm looking for a formula that can help me identifying a blank cell (without value) between a range of cells with 1 as value.

When a blank cell in a row is identified, I would like a marker (e.g. letter X) as return value.

Example 1 where I would like to identify that there is a blank/an empty cell between C77 and E77:

Row no.        Col. A      Col. B      Col. C      Col. D      Col. E
77                [blank]      [blank]          1          [blank]          1


Example 2 where I would like to identify that there are blanks/empty cells between A253 and C253 and between C253 and E253:

Row            Col. A      Col. B      Col. C      Col. D      Col. E
253                  1          [blank]          1            [blank]          1

Sorry, that I can't show the examples with spacing.

How can I write a formula that identify these blank cells?

Thanks in advance for your help.

Kind regards,
Arne
Avatar billede MaxZpaD Guru
09. oktober 2024 - 16:47 #1
In my opinion, the fastest way to do this is by the following steps:

- Mark your entire data range
- Keyboard shortcut Ctrl + G (Go to)
- Select button Special...
- Click radio button for Empty cells
- Click OK
- Now, with all empty cells selected type X followed by Ctrl + Enter

All empty cells should then contain X
Avatar billede xl-Enthusiast Ekspert
10. oktober 2024 - 07:23 #2
Avatar billede Nuser2008 Mester
13. oktober 2024 - 19:45 #3
Thanks, guys

@MaxZpaD: Thanks, I go with your solution.

@xl-Enthusiast: Sorry, but I couldn't try your solution due to security restrictions on my laptop (link to dropbox.com). But thanks anyway.
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Vi har et stort udvalg af Excel kurser. Find lige det kursus der passer dig lige her.

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester