For the best help attach a sample workbook to your post
New Notice for experts and gurus:
Recently, it has become clear that some members (especially newer members) have been confused by "mixed messages" coming from non-Moderators. They are unclear how to react to such requests. Accordingly, we are now asking all members NOT to attempt to moderate threads. From now on, that will be done by forum Moderators only.We continue to encourage the reporting of posts/threads where cross-posting has not been declared, where measures to bypass sheet security are requested, or where abusive language is being used. Generally speaking, it it NOT necessary to report poor titles, spam, lack of code tags, etc, as these are easily spotted by forum Moderators.From now on, those posts made by non-Mods that are attempting to carry out Moderation activities will be deleted.

Search:

Tag: blank

Search: Replies Views Search took 0.00 seconds.

[SOLVED] Comparing two dates and ignoring blank cells

Started by TSLRachel‎, 12-11-2024 08:50 AM
- 4
- 202
Last Post By:

Last Post: 12-11-2024 06:42 PM

by josephteh

Forum:
Excel Formulas & Functions
[SOLVED] Need help with IF function where one of the condition is related to blank cells

Started by adx‎, 09-25-2024 07:52 AM
- 7
- 369
Last Post By:

Last Post: 09-26-2024 03:22 AM

by AliGW

Forum:
Excel Formulas & Functions
[SOLVED] How COUNTA deals with blanks and arrays

Started by Dicken‎, 09-21-2024 12:52 PM
- 5
- 426
Last Post By:

Last Post: 09-22-2024 07:47 PM

by wk9128

Forum:
Excel General
Pasting data into excel gives extra blank rows

Started by mrshgoodwin13‎, 09-13-2024 09:45 AM
- 1
- 242
Last Post By:

Last Post: 09-13-2024 09:46 AM

by AliGW

Forum:
Excel General
Fill in Column's Blank Cells with the average of the two cells above and below

Started by Bradcab75‎, 08-19-2024 10:08 AM
- 2
- 184
Last Post By:

Last Post: 08-19-2024 10:16 AM

by Pepe Le Mokko

Forum:
Excel Formulas & Functions
Return cell A, if blank return B if blank return cell C etc...

Started by twrtleduck‎, 05-17-2024 05:27 PM
- 3
- 335
Last Post By:

Last Post: 05-17-2024 08:50 PM

by Phuocam

Forum:
Excel Formulas & Functions
Pivot used to have a column label (blank), now just displays a less-than date field

Started by thickage‎, 05-07-2024 08:22 AM
- 3
- 290
Last Post By:

Last Post: 05-07-2024 10:58 AM

by romperstomper

Forum:
Excel Charting & Pivots
Populate a selected cell

Started by varbergt‎, 04-10-2024 07:05 AM
- 5
- 337
Last Post By:

Last Post: 04-10-2024 12:08 PM

by MohamedGadAllah

Forum:
Excel Formulas & Functions
[SOLVED] Return blank instead of 0 with =SUM(SUMIFS formula

Started by varbergt‎, 03-06-2024 08:41 AM
- 6
- 412
Last Post By:

Last Post: 03-07-2024 07:29 AM

by Fluff13

Forum:
Excel Formulas & Functions
[SOLVED] Index Match to Skip/Ignore Blanks in Row

Started by 77highland‎, 02-07-2023 08:22 PM
- 12
- 813
Last Post By:

Last Post: 02-07-2023 10:39 PM

by Glenn Kennedy

Forum:
Excel Formulas & Functions
Average/Sum Ignoring Blanks In-Range Help

Started by Metapotamus‎, 01-30-2023 08:08 PM
- 9
- 603
Last Post By:

Last Post: 01-31-2023 07:37 AM

by wk9128

Forum:
Excel Formulas & Functions
Pivot table blank row names in groups and subgroups

Started by artursa‎, 01-19-2023 03:41 AM
- 2
- 684
Last Post By:

Last Post: 01-20-2023 02:15 AM

by artursa

Forum:
Excel Charting & Pivots
[SOLVED] Formula Not Calculating

Started by Weebs21‎, 10-20-2022 10:24 AM
- 4
- 458
Last Post By:

Last Post: 10-20-2022 12:07 PM

by Glenn Kennedy

Forum:
Excel Formulas & Functions
[SOLVED] Removing Blank Rows in Singular Cell

Started by Ekazumon‎, 10-12-2022 04:04 PM
- 6
- 499
Last Post By:

Last Post: 10-18-2022 12:18 PM

by HansDouwe

Forum:
Excel Formulas & Functions
Formula to automatically update cell entry based on whether other cells are empty or not

Started by kbrown123456‎, 04-22-2022 11:52 AM
- 4
- 367
Last Post By:

Last Post: 04-22-2022 12:11 PM

by Glenn Kennedy

Forum:
Excel Formulas & Functions
Calculate average only if all cells include values. Also use OFFSET for dynamic range.

Started by jpowellzy‎, 10-19-2021 09:00 AM
- 11
- 1,177
Last Post By:

Last Post: 10-22-2021 10:54 AM

by JeteMc

Forum:
Excel Formulas & Functions
Removing blank spaces between number

Started by Urian‎, 10-14-2021 03:46 PM
- 13
- 936
Last Post By:

Last Post: 10-15-2021 11:25 AM

by alansidman

Forum:
Excel General
value EVEN if cells are blank

Started by AawwYeahh‎, 10-01-2021 08:50 AM
- 5
- 429
Last Post By:

Last Post: 10-01-2021 09:12 AM

by JohnTopley

Forum:
Excel Formulas & Functions
Count no. of words in cell, put 0 for blanks

Started by rayted‎, 05-13-2021 04:48 AM
- 1
- 429
Last Post By:

Last Post: 05-13-2021 04:58 AM

by Phuocam

Forum:
Excel Formulas & Functions
[SOLVED] Return blank if range is blank

Started by vill‎, 04-14-2021 07:00 AM
- 3
- 420
Last Post By:

Last Post: 04-14-2021 07:17 AM

by vill

Forum:
Excel Formulas & Functions
[SOLVED] wrap formula to allow cell to stay blank instead of showing #N/A

Started by Hedy‎, 03-16-2021 11:15 AM
- 4
- 448
Last Post By:

Last Post: 03-16-2021 11:27 AM

by Fluff13

Forum:
Excel Formulas & Functions
[SOLVED] Getting array/index formula to ignore blank cells

Started by LandSim‎, 03-03-2021 01:03 PM
- 5
- 1,861
Last Post By:

Last Post: 07-14-2021 04:14 PM

by Cathrine Paul

Forum:
Excel Formulas & Functions
Omitting blank cells or just reading them as zero.

Started by FabFranno‎, 01-14-2021 05:04 PM
- 4
- 635
Last Post By:

Last Post: 01-15-2021 01:00 AM

by kvsrinivasamurthy

Forum:
Excel Formulas & Functions
[SOLVED] Removing Blank from Pivot and Slicer

Started by MagnusNovak‎, 12-13-2020 01:54 PM
- 4
- 6,980
Last Post By:

Last Post: 12-14-2020 08:01 PM

by MagnusNovak

Forum:
Excel Charting & Pivots
[SOLVED] IF Cell is Blank, Show Blank, Otherwise do Sum - Not Working

Started by Mrrrr‎, 09-11-2020 01:52 AM
- 3
- 1,284
Last Post By:

Last Post: 09-14-2020 05:35 AM

by Mrrrr

Forum:
Word Formatting & General
[SOLVED] Average if range not blank

Started by adame‎, 06-23-2020 10:54 AM
- 5
- 986
Last Post By:

Last Post: 06-25-2020 06:26 AM

by ORoos

Forum:
Excel General
Ignore blank cells

Started by rickyc165‎, 03-27-2020 06:35 AM
- 3
- 556
Last Post By:

Last Post: 03-31-2020 07:08 AM

by sweep

Forum:
Excel Formulas & Functions
Automatically calculate mean time between list of dates while ignoring blank cells in list

Started by mbagc‎, 02-20-2020 11:15 AM
- 6
- 698
Last Post By:

Last Post: 02-20-2020 12:44 PM

by Bernie Deitrick

Forum:
Excel Formulas & Functions
[SOLVED] Formula to return a value from one column based on date in one col and no date in other

Started by Hedy‎, 01-28-2020 04:20 PM
- 2
- 577
Last Post By:

Last Post: 01-28-2020 04:35 PM

by Hedy

Forum:
Excel Formulas & Functions
[SOLVED] SOLVED - Averaging weighted scores without counting blanks

Started by BamaRatt‎, 01-20-2020 01:39 PM
- 1
- 628
Last Post By:

Last Post: 01-20-2020 02:00 PM

by BamaRatt

Forum:
Excel Formulas & Functions
Comparing two rows for exact match

Started by dhoath‎, 10-17-2019 10:56 AM
- 13
- 855
Last Post By:

Last Post: 10-18-2019 04:23 AM

by Special-K

Forum:
Excel Formulas & Functions
[SOLVED] Adjustments to sumproduct to ignore if all entries at each date is blank

Started by Phil123456789‎, 09-17-2019 07:31 AM
- 7
- 696
Last Post By:

Last Post: 09-20-2019 05:31 AM

by Phil123456789

Forum:
Excel Formulas & Functions
[SOLVED] If 2 results don't match, how can I make a 'Total' cell show 0, right now it shows 2 or 5

Started by zakwebb47‎, 08-16-2019 08:23 AM
- 5
- 731
Last Post By:

Last Post: 08-17-2019 05:02 PM

by protonLeah

Forum:
Excel Formulas & Functions
[SOLVED] COUNTIFS formula problem - return blank or less than

Started by mc84excel‎, 08-08-2019 08:29 PM
- 4
- 543
Last Post By:

Last Post: 08-13-2019 10:36 PM

by Thomasmas

Forum:
Excel Formulas & Functions
Nested If with blank cells not working

Started by Travis83‎, 07-15-2019 05:48 PM
- 2
- 566
Last Post By:

Last Post: 07-15-2019 08:52 PM

by Pete_UK

Forum:
Excel Formulas & Functions

Results 1 to 35 of 159

Search: Replies Views Search took 0.00 seconds.

[SOLVED] Comparing two dates and ignoring blank cells

[SOLVED] Need help with IF function where one of the condition is related to blank cells

[SOLVED] How COUNTA deals with blanks and arrays

[SOLVED] Return blank instead of 0 with =SUM(SUMIFS formula

[SOLVED] Index Match to Skip/Ignore Blanks in Row

[SOLVED] Formula Not Calculating

[SOLVED] Removing Blank Rows in Singular Cell

[SOLVED] Return blank if range is blank

[SOLVED] wrap formula to allow cell to stay blank instead of showing #N/A

[SOLVED] Getting array/index formula to ignore blank cells

[SOLVED] Removing Blank from Pivot and Slicer

[SOLVED] IF Cell is Blank, Show Blank, Otherwise do Sum - Not Working

[SOLVED] Average if range not blank

[SOLVED] Formula to return a value from one column based on date in one col and no date in other

[SOLVED] SOLVED - Averaging weighted scores without counting blanks

[SOLVED] Adjustments to sumproduct to ignore if all entries at each date is blank

[SOLVED] If 2 results don't match, how can I make a 'Total' cell show 0, right now it shows 2 or 5

[SOLVED] COUNTIFS formula problem - return blank or less than