formulas - Search Results - Excel Help Forum

[SOLVED] Help - Replace a string in a whole workbook inside formulas

Started by Alexander2020‎, 05-29-2020 07:00 AM

8

631

Last Post By:: Last Post: 06-02-2020 04:08 PM; by Alexander2020

Forum:
Excel Programming / VBA / Macros

Count cells in a range that are NOT blank and are NOT "N/A"

Started by russoagain‎, 05-26-2020 10:53 AM

2

494

Last Post By:: Last Post: 05-26-2020 11:19 AM; by davsth

Forum:
Excel Formulas & Functions

Text join ignoring blanks but limited to a maximum of five entries

Started by JFawcett‎, 05-24-2020 11:25 AM

formulas, function, join, textjoin, textjoin function

10

1,374

Last Post By:: Last Post: 05-26-2020 03:54 AM; by XOR LX

Forum:
Excel Formulas & Functions

How Can I check the earliest date in Rows

Started by funktheory‎, 05-20-2020 11:37 AM

4

424

Last Post By:: Last Post: 05-20-2020 12:48 PM; by funktheory

Forum:
Excel Formulas & Functions

Keep date format when using a formula

Started by Modify_inc‎, 05-03-2020 07:02 PM

1

800

Last Post By:: Last Post: 05-03-2020 07:54 PM; by alansidman

Forum:
Excel General

[SOLVED] Compare 4 columns

Started by John1974‎, 04-28-2020 12:37 PM

17

2,177

Last Post By:: Last Post: 05-06-2020 12:13 PM; by alansidman

Forum:
Excel Formulas & Functions

VBA - How to make formulas dynamic when inserting new rows?

Started by Jeoffrey3‎, 04-09-2020 05:35 AM

3

756

Last Post By:: Last Post: 04-09-2020 10:00 AM; by alansidman

Forum:
Excel Programming / VBA / Macros

[SOLVED] Date formula with ISBLANK or IF condition from previous column entry

Started by Screwtape‎, 04-06-2020 08:51 AM

8

466

Last Post By:: Last Post: 04-06-2020 09:36 AM; by Fluff13

Forum:
Excel - New Users/Basics

[SOLVED] INDEX-MATCH with Multiple Row Criteria?

Started by eNinjaInTraining‎, 03-26-2020 02:21 PM

4

521

Last Post By:: Last Post: 03-27-2020 11:00 AM; by Fluff13

Forum:
Excel Formulas & Functions

Adding and inserting new rows - Keep formulas

Started by Jeoffrey3‎, 03-23-2020 12:54 PM

4

3,005

Last Post By:: Last Post: 03-31-2020 11:10 AM; by Pepe Le Mokko

Forum:
Excel General

Average values while removing outliers

Started by Lsxtrkiller‎, 03-18-2020 04:18 PM

average, averageifs, data, formulas, formulas & functions

3

3,808

Last Post By:: Last Post: 03-19-2020 02:52 AM; by joeu2004

Forum:
Excel Formulas & Functions

Array formula working in one workbook but not another

Started by vwhite‎, 02-26-2020 09:19 AM

array formula error, circular reference error, formulas, tables, workbooks

1

513

Last Post By:: Last Post: 02-26-2020 09:21 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Need help creating formula for conditional icons

Started by Keegan1116‎, 02-19-2020 02:50 PM

formula assistance, formulas, icon sets with formula

3

596

Last Post By:: Last Post: 02-19-2020 03:22 PM; by Fluff13

Forum:
Excel General

[SOLVED] SUMIF positive numbers with multiple criteria

Started by mfleetwood9437‎, 02-12-2020 03:01 PM

7

552

Last Post By:: Last Post: 02-12-2020 08:38 PM; by Pete_UK

Forum:
Excel Formulas & Functions

conditional formatting based on another cell & leave blank cells

Started by Gall47‎, 01-31-2020 06:40 AM

5

489

Last Post By:: Last Post: 01-31-2020 10:58 AM; by Gall47

Forum:
Excel Formulas & Functions

[SOLVED] Can I dynamically convert reference values to actual values at the end of a quarter?

Started by cindybert‎, 01-30-2020 04:41 PM

8

511

Last Post By:: Last Post: 02-13-2020 04:16 PM; by cindybert

Forum:
Excel Formulas & Functions

[SOLVED] Formula that pulls a value based on 2 different criteria ranges

Started by osugirl7‎, 01-29-2020 06:18 PM

6

325

Last Post By:: Last Post: 01-31-2020 12:38 PM; by FlameRetired

Forum:
Excel Formulas & Functions

Index Match with Indirect and Named Range

Started by hikari8‎, 01-27-2020 01:35 PM

excel, excel formula, formulas, index match, indirect formula

44

3,241

Last Post By:: Last Post: 01-31-2020 07:50 AM; by XLent

Forum:
Excel Formulas & Functions

[SOLVED] Easily Updating Formulas

Started by Vladmiris‎, 01-09-2020 07:24 AM

5

416

Last Post By:: Last Post: 01-09-2020 08:34 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Multiple greater than and less than variables

Started by burkey301193‎, 12-10-2019 10:41 AM

excel, formulas, greater than, less than, probationary

7

583

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

Forum:
Excel Formulas & Functions

How to work two pivots together!

Started by makaii‎, 12-06-2019 12:16 PM

cross reference, formulas, getpivotdata, pivot

1

400

Last Post By:: Last Post: 12-08-2019 11:45 AM; by Ace_XL

Forum:
Excel Formulas & Functions

[SOLVED] Look up value in column to match active sheet name and insert row

Started by sebi171‎, 12-05-2019 01:27 PM

catagories, excel & macro, formulas, sheets, vba

2

428

Last Post By:: Last Post: 12-05-2019 02:28 PM; by sebi171

Forum:
Excel Programming / VBA / Macros

Formula to Insert Fortnightly Bills in Table

Started by XLReverseEngineering‎, 12-05-2019 08:16 AM

finance, forecasting, formulas, fortnightly payments, quarterly payments

3

697

Last Post By:: Last Post: 12-09-2019 11:02 AM; by JeteMc

Forum:
Excel Formulas & Functions

Conditional Formatting by Date Range

Started by amba.tadaa‎, 11-23-2019 06:14 AM

3

510

Last Post By:: Last Post: 11-23-2019 06:53 AM; by BanginMyHeadOnMyDesk

Forum:
Excel Formulas & Functions

Formula dates on in and out equipment.

Started by israelalvarado‎, 11-19-2019 12:05 PM

7

462

Last Post By:: Last Post: 11-22-2019 02:39 AM; by JeteMc

Forum:
Excel Formulas & Functions

Using multiple IF's and RANGEs in one formula

Started by MKLCHEMS‎, 11-11-2019 07:49 AM

2

707

Last Post By:: Last Post: 11-11-2019 09:18 AM; by MKLCHEMS

Forum:
Excel General

Help calculting negative actuals into positive target

Started by feulner‎, 11-08-2019 01:21 PM

excel, formulas, negative actuals, positive target

14

3,590

Last Post By:: Last Post: 11-12-2019 03:56 PM; by loginjmor

Forum:
Excel Formulas & Functions

Formula to add a value to every row until the next value appears? (Example Inside)

Started by kreynol3‎, 11-04-2019 03:37 PM

3

812

Last Post By:: Last Post: 12-06-2019 03:05 PM; by kreynol3

Forum:
Excel General

Issues Displaying String Of Text From A Formula

Started by stocksweepers‎, 10-28-2019 09:22 AM

7

344

Last Post By:: Last Post: 10-29-2019 04:38 AM; by PaulM100

Forum:
Excel Formulas & Functions

Using Fromulas for cell references in the Sum() Function

Started by RinBarrett‎, 10-26-2019 11:20 AM

7

534

Last Post By:: Last Post: 10-27-2019 03:17 PM; by Fluff13

Forum:
Excel Formulas & Functions

Lookup to a Moving Lookup Reference

Started by mv0826‎, 10-25-2019 09:33 AM

15

502

Last Post By:: Last Post: 10-25-2019 10:19 AM; by AliGW

Forum:
Excel Formulas & Functions

How to keep formulas from returning error when I paste in new data

Started by JamieC77‎, 10-10-2019 09:10 AM

2

235

Last Post By:: Last Post: 10-10-2019 09:15 AM; by modytrane

Forum:
Excel Formulas & Functions

Counting Values Until Number Reached, Then Returning Cells Counted

Started by ExtraLarge‎, 10-07-2019 09:25 AM

count, counting, formula, formulas, formulas & functions

7

1,227

Last Post By:: Last Post: 10-10-2019 11:57 AM; by Alf

Forum:
Excel General

Teacher looking for help with IFS possibly

Started by JeffHughes‎, 10-04-2019 10:58 AM

1

584

Last Post By:: Last Post: 10-04-2019 11:17 AM; by CK76

Forum:
Excel Formulas & Functions

Links, formatting and attachments from tab to another not working due to formulas?

Started by stingx‎, 09-29-2019 07:43 AM

2

457

Last Post By:: Last Post: 09-29-2019 04:39 PM; by stingx

Forum:
Excel General

Search:

Search: Replies Views Search took 0.01 seconds; generated 15 minute(s) ago.

[SOLVED] Help - Replace a string in a whole workbook inside formulas

Count cells in a range that are NOT blank and are NOT "N/A"

Text join ignoring blanks but limited to a maximum of five entries

How Can I check the earliest date in Rows

Keep date format when using a formula

[SOLVED] Compare 4 columns

VBA - How to make formulas dynamic when inserting new rows?

[SOLVED] Date formula with ISBLANK or IF condition from previous column entry

[SOLVED] INDEX-MATCH with Multiple Row Criteria?

Adding and inserting new rows - Keep formulas

Average values while removing outliers

Array formula working in one workbook but not another

[SOLVED] Need help creating formula for conditional icons

[SOLVED] SUMIF positive numbers with multiple criteria

conditional formatting based on another cell & leave blank cells

[SOLVED] Can I dynamically convert reference values to actual values at the end of a quarter?

[SOLVED] Formula that pulls a value based on 2 different criteria ranges

Index Match with Indirect and Named Range

[SOLVED] Easily Updating Formulas

[SOLVED] Multiple greater than and less than variables

How to work two pivots together!

[SOLVED] Look up value in column to match active sheet name and insert row

Formula to Insert Fortnightly Bills in Table

Conditional Formatting by Date Range

Formula dates on in and out equipment.

Using multiple IF's and RANGEs in one formula

Help calculting negative actuals into positive target

Formula to add a value to every row until the next value appears? (Example Inside)

Issues Displaying String Of Text From A Formula

Using Fromulas for cell references in the Sum() Function

Lookup to a Moving Lookup Reference

How to keep formulas from returning error when I paste in new data

Counting Values Until Number Reached, Then Returning Cells Counted

Teacher looking for help with IFS possibly

Links, formatting and attachments from tab to another not working due to formulas?