blank cell

[SOLVED] Formula returns #Value! when + empty cell with formula with cell with value and formula

Started by varbergt‎, 04-11-2024 03:55 AM

9

121

Last Post By:: Last Post: 04-11-2024 05:43 AM; by HansDouwe

Forum:
Excel Formulas & Functions

if statement not differentiating between blank cell and a zero

Started by carrollm‎, 03-02-2024 09:09 AM

4

157

Last Post By:: Last Post: 03-02-2024 01:48 PM; by AliGW

Forum:
Excel Formulas & Functions

Sum of values corresponding to a range of cells

Started by AndrewSheffieldUK‎, 01-30-2024 08:29 PM

blank cell, skip blank cells, sum of data, sum until new data, total amount

9

302

Last Post By:: Last Post: 01-31-2024 05:07 PM; by DJunqueira

Forum:
Excel Formulas & Functions

trying to add another formula to existing formula

Started by angie1h‎, 10-06-2023 08:16 PM

2

156

Last Post By:: Last Post: 10-06-2023 10:24 PM; by Gregb11

Forum:
Excel Formulas & Functions

Random pick a cell content in a range ignoring all blank/empty cells in that range

Started by willywaai‎, 09-10-2023 06:43 AM

blank cell, empty cells., random cell value

12

308

Last Post By:: Last Post: 09-11-2023 03:33 AM; by willywaai

Forum:
Excel Formulas & Functions

[SOLVED] Budget reduction column

Started by brvheart‎, 08-04-2023 01:01 PM

blank cell, budget, difference, isblank, sumifs

4

238

Last Post By:: Last Post: 08-05-2023 01:04 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] sumproduct with date criteria and blanks in array

Started by moneypennie21‎, 01-03-2023 09:27 AM

13

431

Last Post By:: Last Post: 01-03-2023 10:49 AM; by Fluff13

Forum:
Excel Formulas & Functions

Concatenate cells on same row ignoring blank cells

Started by RJK‎, 12-30-2022 05:28 PM

blank cell, concatenate, separated by semicolon

4

373

Last Post By:: Last Post: 12-31-2022 12:17 AM; by RJK

Forum:
Excel Formulas & Functions

[SOLVED] Keep cell blank or with 0:00 value

Started by doe2‎, 10-24-2022 04:10 AM

9

196

Last Post By:: Last Post: 10-24-2022 05:00 AM; by AliGW

Forum:
Excel Formulas & Functions

Blank TextBox values and Listbox

Started by SimonCampbell‎, 11-17-2021 07:55 AM

3

433

Last Post By:: Last Post: 11-17-2021 09:25 AM; by SimonCampbell

Forum:
Excel Programming / VBA / Macros

Return cell, if cell is blank (ignorer formula in blank cell) return cell X

Started by twrtleduck‎, 11-16-2021 04:55 PM

2

337

Last Post By:: Last Post: 11-16-2021 05:57 PM; by twrtleduck

Forum:
Excel General

Help: concatenate, skip blanks, add line break

Started by tiggynook‎, 11-01-2021 12:01 PM

4

557

Last Post By:: Last Post: 11-03-2021 10:30 AM; by tiggynook

Forum:
Excel Formulas & Functions

[SOLVED] Number of Days Calculation

Started by Sugarprincess21‎, 11-01-2021 11:28 AM

4

371

Last Post By:: Last Post: 11-01-2021 02:14 PM; by Sugarprincess21

Forum:
Excel Formulas & Functions

Check to see if nth cell is blank

Started by Baccawastaken‎, 07-27-2021 06:38 PM

6

684

Last Post By:: Last Post: 07-29-2021 10:33 AM; by davsth

Forum:
Excel Formulas & Functions

Ignoring Blank Cell

Started by jakew38197‎, 05-11-2021 06:15 AM

6

415

Last Post By:: Last Post: 05-11-2021 10:24 AM; by jakew38197

Forum:
Excel Formulas & Functions

[SOLVED] How do I enter a blank cell for formulas that have no data to calculate

Started by cableghost‎, 05-10-2021 12:38 PM

2

224

Last Post By:: Last Post: 05-10-2021 12:46 PM; by cableghost

Forum:
Excel Formulas & Functions

[SOLVED] Pulling data from another sheet based on certain criteria, without creating blank rows

Started by afreed33‎, 04-27-2021 12:28 AM

blank cell, copying data, criteria, formula

2

882

Last Post By:: Last Post: 04-27-2021 04:37 PM; by afreed33

Forum:
Excel Formulas & Functions

[SOLVED] COUNTIFS with blank cells

Started by NiallC92‎, 03-20-2021 05:13 PM

10

657

Last Post By:: Last Post: 03-21-2021 07:30 AM; by Gregb11

Forum:
Excel Formulas & Functions

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

Started by LandSim‎, 03-03-2021 01:03 PM

5

912

Last Post By:: Last Post: 07-14-2021 04:14 PM; by Cathrine Paul

Forum:
Excel Formulas & Functions

[SOLVED] Conditional Formatting - Highlighting whole row

Started by tonimarie797‎, 01-15-2021 03:39 PM

blank cell, condition formatting, conditional format, excel, help a dummy

7

1,427

Last Post By:: Last Post: 01-15-2021 04:20 PM; by tonimarie797

Forum:
Excel General

Remove Blank Lines That Show Up During Sorting

Started by Modify_inc‎, 12-17-2020 04:49 PM

1

345

Last Post By:: Last Post: 12-18-2020 08:48 AM; by sintek

Forum:
Excel Programming / VBA / Macros

Dragging with blank cells

Started by niazi‎, 05-31-2020 01:20 AM

5

456

Last Post By:: Last Post: 06-01-2020 05:27 AM; by Beamernsw

Forum:
Excel Formulas & Functions

How to filter multiple columns in order to keep all rows with at least one marking

Started by StefR‎, 02-14-2020 08:32 AM

blank cell, columns, filter, multiple, table

1

1,013

Last Post By:: Last Post: 02-14-2020 12:47 PM; by Akuini

Forum:
Excel General

[SOLVED] Formula to extract nonblanks via dropdown list

Started by Excelol‎, 11-18-2019 06:54 PM

blank cell, drop down list, extract data

7

664

Last Post By:: Last Post: 11-22-2019 06:56 AM; by Excelol

Forum:
Excel Formulas & Functions

Autopopulate Data to multiple sheets while eliminating zero or blank cells

Started by teamdynasty27‎, 10-23-2019 09:54 AM

0 cell, blank cell, empty cell, sort & filter

11

490

Last Post By:: Last Post: 10-25-2019 12:31 PM; by Pete_UK

Forum:
Excel Formulas & Functions

Started by krnath77‎, 09-28-2019 06:48 PM

3

430

Last Post By:: Last Post: 09-29-2019 12:29 PM; by Roel Jongman

Forum:
Excel Formulas & Functions

INDEX MATCH to ignore blank cells in array

Started by Leaflock‎, 09-05-2019 12:33 AM

9

7,701

Last Post By:: Last Post: 09-05-2019 06:36 PM; by Leaflock

Forum:
Excel Formulas & Functions

[SOLVED] IF statement using multiple cells. Result should consider whether cells are blank

Started by harrysolomon‎, 08-13-2019 12:17 PM

blank cell, if statement, multiple condition

9

535

Last Post By:: Last Post: 08-13-2019 12:40 PM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Equivalent to java break(); function in basic excel formulas?

Started by Sprong‎, 05-21-2019 05:24 PM

2

472

Last Post By:: Last Post: 05-21-2019 06:07 PM; by Sprong

Forum:
Excel General

[SOLVED] How to Have Two Cells Impacted by a Password Protected Cell

Started by Kamily‎, 04-30-2019 09:59 AM

blank cell, dropdown list, macro, password protect cell, vba

7

526

Last Post By:: Last Post: 04-30-2019 05:53 PM; by Keebellah

Forum:
Excel Programming / VBA / Macros

Subtracting non-blank cells only

Started by levpn‎, 02-15-2019 04:57 PM

9

4,818

Last Post By:: Last Post: 02-16-2019 03:22 PM; by GeoffW283

Forum:
Excel Formulas & Functions

First and Last Instance within Date Range

Started by Peelah‎, 01-14-2019 03:38 PM

3

545

Last Post By:: Last Post: 01-14-2019 05:33 PM; by AliGW

Forum:
Excel Formulas & Functions

Extracting Only Non-Blanks

Started by spudder6‎, 11-20-2018 11:24 AM

blank cell, blanks in range, extract non-blanks, help a student in need

2

706

Last Post By:: Last Post: 11-20-2018 11:31 AM; by 63falcondude

Forum:
Excel Formulas & Functions

[SOLVED] If not all cells have data prohibit from saving

Started by Rachel5694‎, 10-24-2018 07:02 PM

blank cell, error message, saving, vba code, vba help

19

1,034

Last Post By:: Last Post: 11-03-2018 12:41 PM; by Winon

Forum:
Excel Programming / VBA / Macros

Average formula to deal with blanks in sub calculations

Started by BryceVBA‎, 09-26-2018 04:48 PM

8

599

Last Post By:: Last Post: 09-27-2018 04:48 PM; by FDibbins

Forum:
Excel Formulas & Functions

Search:

Search: Replies Views Search took 0.00 seconds; generated 58 minute(s) ago.

[SOLVED] Formula returns #Value! when + empty cell with formula with cell with value and formula

if statement not differentiating between blank cell and a zero

Sum of values corresponding to a range of cells

trying to add another formula to existing formula

Random pick a cell content in a range ignoring all blank/empty cells in that range

[SOLVED] Budget reduction column

[SOLVED] sumproduct with date criteria and blanks in array

Concatenate cells on same row ignoring blank cells

[SOLVED] Keep cell blank or with 0:00 value

Blank TextBox values and Listbox

Return cell, if cell is blank (ignorer formula in blank cell) return cell X

Help: concatenate, skip blanks, add line break

[SOLVED] Number of Days Calculation

Check to see if nth cell is blank

Ignoring Blank Cell

[SOLVED] How do I enter a blank cell for formulas that have no data to calculate

[SOLVED] Pulling data from another sheet based on certain criteria, without creating blank rows

[SOLVED] COUNTIFS with blank cells

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

[SOLVED] Conditional Formatting - Highlighting whole row

Remove Blank Lines That Show Up During Sorting

Dragging with blank cells

How to filter multiple columns in order to keep all rows with at least one marking

[SOLVED] Formula to extract nonblanks via dropdown list

Autopopulate Data to multiple sheets while eliminating zero or blank cells

Blank cell

INDEX MATCH to ignore blank cells in array

[SOLVED] IF statement using multiple cells. Result should consider whether cells are blank

[SOLVED] Equivalent to java break(); function in basic excel formulas?

[SOLVED] How to Have Two Cells Impacted by a Password Protected Cell

Subtracting non-blank cells only

First and Last Instance within Date Range

Extracting Only Non-Blanks

[SOLVED] If not all cells have data prohibit from saving

Average formula to deal with blanks in sub calculations