Ask Your Question

Lookup smallest in column [closed]

asked 2020-10-21 19:00:20 +0100

TomH2020 gravatar image

I am trying to put together a smart 'check register' .... column A is the date of the transaction, colomn B is the amount, column F is the amount processed based on today's date ... column H is the resulting balance of as of todays date ... ... In column A & B, I have all known Debits and Credits some in the future all shown with respective dates ... ... Column J is the account value of all transactions, including all not yet processed ... ...

What I am trying to do now is find the smallest value in column J from today forward. I see a lookup function looking link this, (but it does not work) .. =lookup(small, today:a999, ?????:j999) ---????? is the same row as today is on in column A but in column J ---

If you think you can help, I have a sample of my data that I can purlish or send to you ... thanks for looking

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by m.a.riosv
close date 2020-10-25 10:42:32.305605

2 Answers

Sort by » oldest newest most voted

answered 2020-10-24 00:23:39 +0100

TomH2020 gravatar image

withdrawn question

edit flag offensive delete link more

answered 2020-10-21 19:45:48 +0100

m.a.riosv gravatar image
edit flag offensive delete link more


I must be dense but I can not figure out how to use the MINIFS function.

TomH2020 gravatar imageTomH2020 ( 2020-10-21 20:26:24 +0100 )edit

Then please edit your question and add a sample file with notes about you want to achieve.

m.a.riosv gravatar imagem.a.riosv ( 2020-10-22 13:46:57 +0100 )edit

I will do so in a couple hours ...

TomH2020 gravatar imageTomH2020 ( 2020-10-22 16:32:25 +0100 )edit

Question Tools

1 follower


Asked: 2020-10-21 19:00:20 +0100

Seen: 30 times

Last updated: Oct 24