functions and formula - Search Results

Creating a function to eliminate TRUE variables

Started by theOTHERguy‎, 10-24-2023 04:26 AM

1

101

Last Post By:: Last Post: 10-24-2023 04:27 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Function or Formula to get a value for each cell from multiple logical test.

Started by markkeith‎, 08-16-2022 12:17 PM

complex if statements, employee roster, functions and formula, yearly rotation

11

737

Last Post By:: Last Post: 08-22-2022 04:56 PM; by JeteMc

Forum:
Excel Formulas & Functions

Subtract Values from cells in one sheet from another sheet

Started by Andy C.‎, 08-30-2021 12:40 PM

formula, functions and formula, vba script

2

375

Last Post By:: Last Post: 09-02-2021 04:17 PM; by Andy C.

Forum:
Excel Programming / VBA / Macros

[SOLVED] Help! Calculating stock levels with short expiry, regular deliveries and demand

Started by grasshopper82‎, 05-17-2021 01:52 PM

dates, functions and formula, look up data, tables

1

829

Last Post By:: Last Post: 05-21-2021 05:49 PM; by JeteMc

Forum:
Excel General

[SOLVED] Return y or n based on a particular column, if multiple criteria match

Started by Kinjal Doshi‎, 01-09-2021 07:52 AM

12

656

Last Post By:: Last Post: 01-11-2021 06:01 AM; by Glenn Kennedy

Forum:
Excel Formulas & Functions

If Function

Started by leokhan‎, 08-26-2020 06:04 PM

functions and formula, if statements, then function

1

305

Last Post By:: Last Post: 08-26-2020 08:15 PM; by 6StringJazzer

Forum:
Excel Programming / VBA / Macros

How to match to the closest accurate reference value on Excel

Started by revathyyy‎, 08-12-2020 01:23 AM

1

231

Last Post By:: Last Post: 08-12-2020 01:39 AM; by FDibbins

Forum:
Excel Formulas & Functions

Identify the value in worksheet one and define the same in worksheet 2

Started by shakumxl‎, 05-01-2020 06:17 AM

functions, functions and formula, vlookup

1

367

Last Post By:: Last Post: 05-02-2020 09:29 PM; by JeteMc

Forum:
Excel Formulas & Functions

I need a VLOOKUP function to give me multiple outputs in different cells

Started by bjones148‎, 03-05-2020 11:38 AM

1

301

Last Post By:: Last Post: 03-08-2020 08:04 AM; by etaf

Forum:
Excel Formulas & Functions

LOOKUP and Filter Based on Combined Condition

Started by Steave‎, 12-10-2019 06:23 AM

66

1,236

Last Post By:: Last Post: 12-29-2019 05:16 AM; by Glenn Kennedy

Forum:
Excel Formulas & Functions

[SOLVED] Matching and arriving at Discounts for Various Vendors

Started by chandramouliarun‎, 11-06-2019 06:24 AM

functions and formula, if then else, index and match

3

496

Last Post By:: Last Post: 11-06-2019 07:04 AM; by Pete_UK

Forum:
Excel Formulas & Functions

[SOLVED] Complicated Conditional Formatting across 2 sheets help required

Started by MrMarkS23‎, 10-16-2019 04:23 AM

conditional formatting, functions and formula, multiple sheets

1

446

Last Post By:: Last Post: 10-16-2019 12:41 PM; by 6StringJazzer

Forum:
Excel Formulas & Functions

calculating percentage of sales for promotions

Started by chandramouliarun‎, 07-15-2019 10:49 AM

functions and formula, macro, power query

5

594

Last Post By:: Last Post: 07-18-2019 02:48 AM; by Pepe Le Mokko

Forum:
Excel Formulas & Functions

[SOLVED] Conditional formatting on dates if another cell equals to

Started by Mikkel_pet‎, 07-15-2019 03:43 AM

conditional formatting, function, functions and formula, planning, production

12

599

Last Post By:: Last Post: 07-15-2019 05:15 AM; by AliGW

Forum:
Excel Formulas & Functions

Built 2019 NBA Draft Database. built dropdown combo-box for all players. need 1 more thing

Started by geehowey‎, 07-05-2019 07:17 AM

database, functions and formula, help challenging problem, vba & macro

2

743

Last Post By:: Last Post: 07-05-2019 11:47 PM; by FDibbins

Forum:
Access Tables & Databases

[SOLVED] Count the Maximum contribution factor for every vendor

Started by chandramouliarun‎, 07-01-2019 03:51 AM

count a word, functions and formula, search a range

2

1,727

Last Post By:: Last Post: 07-01-2019 07:06 AM; by chandramouliarun

Forum:
Excel General

Help with a string of IF statements

Started by Conorg‎, 06-24-2019 12:01 PM

functions and formula, if statments, nested if

26

1,532

Last Post By:: Last Post: 01-22-2021 08:12 PM; by JeteMc

Forum:
Excel Formulas & Functions

How to have 'Blanks' (in filter) appear on top

Started by Rahul15292000‎, 04-05-2019 02:18 PM

3

2,685

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

Forum:
Excel General

[SOLVED] Deleting conditional formatting rules from multiple workbooks

Started by LAVA2‎, 01-31-2019 12:03 AM

excel & macro, functions and formula, programming vba, vba, worksheets

4

478

Last Post By:: Last Post: 01-31-2019 03:46 AM; by LAVA2

Forum:
Excel Programming / VBA / Macros

Countif Function to work similarly to Sumif Function

Started by JMC1927‎, 01-24-2019 02:11 PM

3

966

Last Post By:: Last Post: 01-24-2019 04:10 PM; by 63falcondude

Forum:
Excel Formulas & Functions

[SOLVED] Help with look up formula for a value containing in a string of text

Started by cwwazy‎, 01-23-2019 07:19 PM

2

418

Last Post By:: Last Post: 01-23-2019 08:52 PM; by azumi

Forum:
Excel Formulas & Functions

[SOLVED] function to return true/na/false when value doesn't match

Started by pizzabae‎, 10-13-2018 05:59 AM

functions and formula, lookup, match, vlookup

6

1,579

Last Post By:: Last Post: 10-13-2018 12:19 PM; by Bo_Ry

Forum:
Excel General

[SOLVED] Finding and arranging rows then displaying their frequency in descending order:

Started by LAVA2‎, 08-17-2018 08:37 AM

arranging data, excel, formulas, functions and formula, rows and column numbering

2

499

Last Post By:: Last Post: 08-19-2018 05:44 AM; by LAVA2

Forum:
Excel Formulas & Functions

Compare value to individual cells

Started by pacours‎, 05-09-2018 03:00 PM

2

541

Last Post By:: Last Post: 05-09-2018 03:55 PM; by pacours

Forum:
Excel General

[SOLVED] Finding only triple occurances of duplicate items

Started by LAVA2‎, 04-29-2018 11:20 PM

duplicates in column, excel, excel formulas, formulas 2007, functions and formula

3

702

Last Post By:: Last Post: 04-30-2018 05:42 AM; by LAVA2

Forum:
Excel General

Forward Cover Calculation For Horizontal Data

Started by RichardHerbageSCSN‎, 04-10-2018 03:45 PM

5

621

Last Post By:: Last Post: 04-12-2018 10:06 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Syntax for an "IF AND ISNUMBER SEARCH" function

Started by EFD‎, 10-31-2017 07:56 AM

10

4,442

Last Post By:: Last Post: 10-31-2017 09:29 AM; by xlnitwit

Forum:
Excel Formulas & Functions

Function to match two values one in row, another in column

Started by LinaVa‎, 10-31-2017 04:50 AM

double criteria, functions and formula, match, two conditions, vlookup

5

595

Last Post By:: Last Post: 10-31-2017 07:19 AM; by JohnTopley

Forum:
Excel Formulas & Functions

[SOLVED] Using Weekday and CountIf functions to count days in an array

Started by Mongoloid‎, 09-13-2017 10:41 AM

7

1,206

Last Post By:: Last Post: 09-18-2017 04:23 PM; by FlameRetired

Forum:
Excel Formulas & Functions

how to only display first line of each cell

Started by hellownero‎, 08-04-2017 07:22 AM

2

1,180

Last Post By:: Last Post: 08-04-2017 02:14 PM; by hellownero

Forum:
Excel General

Please, advice a more elegant/correct approach to fill the column with values

Started by Vitalite‎, 06-29-2017 06:49 AM

4

493

Last Post By:: Last Post: 06-29-2017 11:30 AM; by Vitalite

Forum:
Excel Formulas & Functions

Need help creating a formula.

Started by sqlishard‎, 06-22-2017 04:43 PM

2

416

Last Post By:: Last Post: 06-22-2017 06:11 PM; by FlameRetired

Forum:
Excel Formulas & Functions

Nested If functions and VLOOKup - PLease help

Started by hameseyed‎, 04-08-2017 08:51 PM

9

709

Last Post By:: Last Post: 04-17-2017 09:42 PM; by hameseyed

Forum:
Excel Formulas & Functions

Divisible IF statements

Started by Wiggy74‎, 12-21-2016 09:28 AM

functions, functions and formula, if statements, mod

5

4,931

Last Post By:: Last Post: 12-21-2016 09:50 AM; by etaf

Forum:
Excel Formulas & Functions

Merging (Copying) data across worksheets

Started by ErvinSehovic‎, 09-28-2016 07:38 AM

1

426

Last Post By:: Last Post: 09-28-2016 09:13 AM; by Bernie Deitrick

Forum:
Excel Formulas & Functions

Search:

Search: Replies Views Search took 0.00 seconds.

Creating a function to eliminate TRUE variables

[SOLVED] Function or Formula to get a value for each cell from multiple logical test.

Subtract Values from cells in one sheet from another sheet

[SOLVED] Help! Calculating stock levels with short expiry, regular deliveries and demand

[SOLVED] Return y or n based on a particular column, if multiple criteria match

If Function

How to match to the closest accurate reference value on Excel

Identify the value in worksheet one and define the same in worksheet 2

I need a VLOOKUP function to give me multiple outputs in different cells

LOOKUP and Filter Based on Combined Condition

[SOLVED] Matching and arriving at Discounts for Various Vendors

[SOLVED] Complicated Conditional Formatting across 2 sheets help required

calculating percentage of sales for promotions

[SOLVED] Conditional formatting on dates if another cell equals to

Built 2019 NBA Draft Database. built dropdown combo-box for all players. need 1 more thing

[SOLVED] Count the Maximum contribution factor for every vendor

Help with a string of IF statements

How to have 'Blanks' (in filter) appear on top

[SOLVED] Deleting conditional formatting rules from multiple workbooks

Countif Function to work similarly to Sumif Function

[SOLVED] Help with look up formula for a value containing in a string of text

[SOLVED] function to return true/na/false when value doesn't match

[SOLVED] Finding and arranging rows then displaying their frequency in descending order:

Compare value to individual cells

[SOLVED] Finding only triple occurances of duplicate items

Forward Cover Calculation For Horizontal Data

[SOLVED] Syntax for an "IF AND ISNUMBER SEARCH" function

Function to match two values one in row, another in column

[SOLVED] Using Weekday and CountIf functions to count days in an array

how to only display first line of each cell

Please, advice a more elegant/correct approach to fill the column with values

Need help creating a formula.

Nested If functions and VLOOKup - PLease help

Divisible IF statements

Merging (Copying) data across worksheets