StackOverflow Questions for Tag: excel-formula

Danieboy
Danieboy

Reputation: 4521

How to keep leading zeroes when pasting into excel file?

Score: 9

Views: 29653

Answers: 5

Read More
John Hendrick
John Hendrick

Reputation: 11

Selecting a dynamic range of cells, dependent on another cell in Excel

Score: 0

Views: 81

Answers: 0

Read More
JSJ
JSJ

Reputation: 55

convert a table of name/value pairs in a spreadsheet into name( value1, value2, ...) strings

Score: 0

Views: 32

Answers: 1

Read More
user13940869
user13940869

Reputation:

EXCEL - Convert TON to KG incorrect

Score: -2

Views: 2447

Answers: 3

Read More
Matthew Perryman
Matthew Perryman

Reputation: 159

Split number into sum of powers of two

Score: 3

Views: 206

Answers: 4

Read More
grovel
grovel

Reputation: 673

Excel Macro, inserting internationally valid formula during run-time

Score: 26

Views: 11454

Answers: 8

Read More
AN Đỗ
AN Đỗ

Reputation: 29

Flatten Parent Child Hierarchy in Excel (using formula or VBA)

Score: 0

Views: 2165

Answers: 4

Read More
Flame
Flame

Reputation: 13

How do I modify my excel IF statement to check for any (not all) True values and not just stop at the first TRUE occurrence

Score: 0

Views: 38

Answers: 0

Read More
Rasec Malkic
Rasec Malkic

Reputation: 695

Compare which values of array1 are present in array2

Score: 1

Views: 43

Answers: 1

Read More
Adi S
Adi S

Reputation: 1

In Excel, Convert duration in text format to duration (years)

Score: -3

Views: 54

Answers: 2

Read More
Pawsome Dog Care
Pawsome Dog Care

Reputation: 1

Excel to Email Recognise Date

Score: 0

Views: 12

Answers: 0

Read More
Vikram
Vikram

Reputation: 4192

Excel now() shouldn't update existing timestamp

Score: 2

Views: 23406

Answers: 5

Read More
SoftTimur
SoftTimur

Reputation: 5540

Keep `0` in the original array

Score: 0

Views: 36

Answers: 2

Read More
Fowzee
Fowzee

Reputation: 89

PIVOTBY #VALUE ERROR when using SUM function - how do I fix?

Score: 0

Views: 49

Answers: 0

Read More
Krishna Kumar
Krishna Kumar

Reputation: 8201

What is the in built function for converting from text to FLOAT in Excel (similar to INT())

Score: 4

Views: 10370

Answers: 1

Read More
Johnny T
Johnny T

Reputation: 13

Fill with value from cell if two other cells' values match

Score: 0

Views: 45

Answers: 2

Read More
Bow
Bow

Reputation: 21

How to retrieve only the first value of a column in a range of an array?

Score: -1

Views: 35

Answers: 2

Read More
Mark Yorsaner
Mark Yorsaner

Reputation: 13

Finding a value in an Excel array

Score: 1

Views: 72

Answers: 1

Read More
Izehiuan Ideho
Izehiuan Ideho

Reputation: 13

How do i use Excel Random list generation without duplicate

Score: 1

Views: 229

Answers: 2

Read More
John Biddle
John Biddle

Reputation: 2686

Need Excel 2016 formula to find THE row in table matching either of 2 criteria in either of two table columns

Score: -3

Views: 76

Answers: 0

Read More
PreviousPage 1Next