2 data Range using COUNTIF with INDIRECT and MIN IF with INDIRECT,

Hi Mr FDibbins,

I tryed to upload the file, but seems too large (3.57mb)

Regarding the

Please Login or Register  to view this content.

is not a problem, i had it in 1200.

The problem is that thoses cell formulas don't read the ROW37 after the Data is updated, it keep pulling information from
the same spot
If read R37 (after Update) it Jump and read R38, if updated again then read R39, if again then R40 ect,etc..

What i need is after each time get data updated, must pull information from R37.

How do manage the Upload when is that big?

Thank you, for fast response

Best regards

David

Hi Mr FDibbins,

I'm sorry, i didn't think about it. some time i act as a dummy

File already uploaded.


Thanks

David

Hi Mr FDibbins,

1. You dont need to use ARRAY formulas for all those countif() formulas (cols Y:AH and in CC2:CG2)
- i'm using array because i research and it was the only think that i get to do the job acording what i need
Question : it is some other formula to do the same and i could use?

2. why did you decide to have your table running from highest date (row 37) to earliest date (A162), instead of having it run from Jan 1 down? This way, you just add data to the end of your table, instead of (I presume) adding a new row for each new day?
-. I need to work with small block of data (not the whole data) but indeed must be the latest data Indeed (highest date)in this case
it's lil difficult to set it the sheet, but later is lot easier to keep and input the info with out mistakes.

-I think I understand what you want, but if you insert a new row for the next date, that row (37?) will always stay 37, and the end of the table will increase (from 162 to 163)

Yes, it might increase up to 6000 but that's is okai, what always need is to work with latest date starting with row 37.


Thank you Sir.



David

Hi Mr FDibbins,

1. You dont need to use ARRAY formulas for all those countif() formulas (cols Y:AH and in CC2:CG2)
- i'm using array because i research and it was the only think that i get to do the job acording what i need
Question : it is some other formula to do the same and i could use?

2. why did you decide to have your table running from highest date (row 37) to earliest date (A162), instead of having it run from Jan 1 down? This way, you just add data to the end of your table, instead of (I presume) adding a new row for each new day?
-. I need to work with small block of data (not the whole data) but indeed must be the latest data (highest date)in this case it's lil difficult to set it the sheet, but later is lot easier to keep and input the info with out mistakes.

-I think I understand what you want, but if you insert a new row for the next date, that row (37?) will always stay 37, and the end of the table will increase (from 162 to 163)

Yes, it might increase up to 6000 but that's is okai, what always need is to work with latest date starting with row 37.


Thank you Sir.



David

Hi Mr FDibbins,

yes mr FDibbins, i tried as regular countif() and read the same,

I forgot to tell you that before my post, i tried in many ways the countif (including with absolute reference on COL then just in Row, etc,etc)


2. Not sure if you read this part of not?

I read it, and it's true, the table will increase from 162 to 163, then 163 to 164,..164.. and is okai, because what matter is that the Formula start to read from Row 37 up to 150 or 200 first lines, if amount of data get bigger it's fine.

You suggest to change the macro to start in row 36?

i just tried and column T37 Get #N/A

David.

Hi Mr FDibbins,

That's what i'm trying to tell you, that already did try in many different ways.
I have installed a Macro to update the data, and is working Fine, even the COUNTIF is working fine, except that After the data is updated, its read the row (38) what i need is to keep reading Row 37.

I Know that COUNTIF function perform this this job and INDIRECT Function keep reading the same Row (that i wish to read)

My two Question are, How do I Apply or put together the:
1-. COUNTIF and the INDIRECT Functions on

Please Login or Register  to view this content.

2-. MIN/IF/ROW and the INDIRECT to

Please Login or Register  to view this content.

Thanks

David

Hi Mr FDibbins,

1-.I load the File and enable the macro,
2-.I click the Update Button to Insert the new data, (as usual )

and workbook get freeze, nothing happen, it won't work

-------------------------- 0000 ------------------------
Matter of Facts, right now i'm creating a macro, with a Command button named "Update C&G Cells"
then i'll be able to
1-. I update the Data
2-. I'll click "Update C&G Cells" Button, to reload the Formula with desire Range.

The Only inconvenience will be that i'll have to click 2 button in order to Update the Data (was clicking 1)

and i think problem be solve it.


Thank you so much sir

Best Regards

David

You're welcome Mr FDibbins

Happy Black Friday !!!!!!!!!!!!!!!!!!


Best Regards from Miami.

David