StackOverflow Questions for Tag: excel-indirect

Jason Smith
Jason Smith

Reputation: 1

Creating n x n array of random #s in Excel sorted by rows?

Score: 0

Views: 78

Answers: 3

Read More
Eric D.
Eric D.

Reputation: 11

How to return all rows containing a certain value using excel formula

Score: 0

Views: 9855

Answers: 1

Read More
MichaelE
MichaelE

Reputation: 837

How to do a row-wise sum in an array formula in Excel?

Score: 4

Views: 11732

Answers: 4

Read More
Jonas Lillhannus
Jonas Lillhannus

Reputation: 1

Calculate the real world length of string in Excel

Score: 0

Views: 61

Answers: 2

Read More
MonqPonx
MonqPonx

Reputation: 21

Extract the number before the mm from a text string in excel

Score: 1

Views: 109

Answers: 5

Read More
Michi
Michi

Reputation: 5471

Transform datatable from column-based to row-based

Score: 1

Views: 55

Answers: 2

Read More
GrayDwarf
GrayDwarf

Reputation: 2737

How do I prevent Excel from automatically replicating formulas in tables?

Score: 8

Views: 85361

Answers: 8

Read More
tommyhmt
tommyhmt

Reputation: 327

Combine most recent 5 records into one cell in Excel

Score: 1

Views: 101

Answers: 4

Read More
Qwerty
Qwerty

Reputation: 85

Excel Pivot Table Calculated Field Max And Min Dynamic With Selected Date Range

Score: 0

Views: 81

Answers: 0

Read More
Anna V
Anna V

Reputation: 1

Spill error caused by array formula not updating at every calculation pass

Score: -2

Views: 58

Answers: 1

Read More
murphychoo
murphychoo

Reputation: 21

How do I get all of the values of the adjacent cell matching a text

Score: 0

Views: 52

Answers: 1

Read More
Derek Dickson
Derek Dickson

Reputation: 13

Matching multiple number rows and check corresponding dates within 90 days

Score: 0

Views: 155

Answers: 3

Read More
Chris Thompson
Chris Thompson

Reputation: 25

Sum all cells for which corresponding cell is not a formula and doesn't return #VALUE AND date occurs in the past

Score: 1

Views: 81

Answers: 1

Read More
Alan Tingey
Alan Tingey

Reputation: 961

How can I use countif to return only a count if sum is > 0 but only count it once

Score: 2

Views: 184

Answers: 4

Read More
deathy
deathy

Reputation: 25

excel No of hours in a shift

Score: 1

Views: 131

Answers: 1

Read More
Mel4342
Mel4342

Reputation: 1

Vba referencing a cell on another worksheet

Score: -5

Views: 58

Answers: 0

Read More
skurt
skurt

Reputation: 1019

How do transform a "matrix"-table to one line for each entry in excel

Score: 4

Views: 9648

Answers: 2

Read More
MartaT
MartaT

Reputation: 1

index match not working for a list of values starting with same text string

Score: 0

Views: 42

Answers: 1

Read More
Nisha
Nisha

Reputation: 407

Apply previous validation formula while copying

Score: 0

Views: 52

Answers: 0

Read More
Laura Pilkington
Laura Pilkington

Reputation: 41

How to convert date to dd/mm/yy in Excel

Score: 2

Views: 10769

Answers: 2

Read More
PreviousPage 2Next