Expense Report

[Donutderek]

Hey guys,

Can anyone help me out with this? I'm creating an expense report, and using rows 10-19. In column K is a spot for "Other" (unspecified expenses) there could be costs located in there, say K11, K13, K14,K18.

What I want to know is how can I automatically list any costs in that column in consecutive order (omitting spaces) in Column D row26-33 on the same Sheet? The mirror of such costs are linked to an area on the page that allows for a detailed description of the "other" expenses.
(I've tried using VLOOKUP, IF, and other formulas but nothing seems to get what I want, I'm probably typing it out wrong- )

I don't know how to show you a glance of what I'm working on to explain it better. So if anyone can help me with that I'd much appreciate it.

 

[Logit]

.
Post a copy of your workbook to a Cloud site like DropBox.com or similar. Then provide the download link here.

 

[Donutderek]

Thanks, Logit.

Here's the idea- I'm just trying to list entries in K in D in consecutive order a little further down the sheet. I've had a few formulas partially work, but I end up with errors.


https://www.dropbox.com/s/ua14fl0exj1lrfy/Screenshot (1).png?dl=0

 

[Fluff]

How about
=IFERROR(INDEX($K$10:$K$19,AGGREGATE(15,6,(ROW($K$10:$K$19)-ROW($K$10)+1)/($K$10:$K$19<>""),ROWS($A$1:$A1))),"")

 

[Donutderek]

Same thing, Fluff. It will list the first amount, but subsequent ones don't appear below. I'm struggling with this one. I want to be able to reuse this formula in other files I'm working on, or I wouldn't be so concerned about getting it to work.

 

[Fluff]

It works for me, with this data

Book1
	D	E	F	G	H	I	J	K
11								56.98
12
13								79
14
15								73.6
16								11
17
18
19
20
21
22
23
24
25
26	56.98
27	79
28	73.6
29	11
Week 42

Cell Formulas
Range	Formula
D26	=IFERROR(INDEX($K$10:$K$19,AGGREGATE(15,6,(ROW($K$10:$K$19)-ROW($K$10)+1)/($K$10:$K$19<>""),ROWS($A$1:$A1))),"")

 

[Donutderek]

My apologies. I don't know what I did wrong, but it does work. Thank you so much! It's been one of those weeks. ?

 

[Fluff]

You're welcome & thanks for the feedback