Macro
Solved/Closed
Related:
- Macro
- Spell number in excel without macro - Guide
- Macro excel download - Download - Spreadsheets
- Excel macro to create new sheet based on value in cells - Guide
- Run macro on opening workbook - Guide
- Excel vba assign macro to button programmatically - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 6, 2010 at 07:41 AM
Jun 6, 2010 at 07:41 AM
For limiting the count of V
you can use data validation
select you data range and enter this formula
=COUNTIF($M18:$GK18, "V")<=$J18
I did not see any graph in your sample workbook
you can use data validation
select you data range and enter this formula
=COUNTIF($M18:$GK18, "V")<=$J18
I did not see any graph in your sample workbook
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 18, 2010 at 10:09 AM
Jun 18, 2010 at 10:09 AM
Depends on what you want to do.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 18, 2010 at 11:41 AM
Jun 18, 2010 at 11:41 AM
Say it again. I am sorry I am now confused. I thought you wanted to use countif with two condtions instead of one
so basicially count if both "apple" and "orange" for example
Could you go into more detail about your issue. If possible, please post a book as you did before and use it to explain.
thanks
so basicially count if both "apple" and "orange" for example
Could you go into more detail about your issue. If possible, please post a book as you did before and use it to explain.
thanks
https://authentification.site/files/23020382/Copy_of_sample.xls
Please see attached. The countif formula was used to limit the count of V only. The spreadsheet has notes.
Please see attached. The countif formula was used to limit the count of V only. The spreadsheet has notes.
