Macro
Solved/Closed
Related:
- Macro
- Excel online macro - Guide
- How to run a macro in excel - Guide
- How to copy macro from one workbook to another - Guide
- Macro for number to words in excel - Guide
- Macro antena apk - Download - Gaming tools
2 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
6 Jun 2010 à 07:41
6 Jun 2010 à 07:41
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 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
18 Jun 2010 à 10:09
18 Jun 2010 à 10:09
Depends on what you want to do.
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
18 Jun 2010 à 11:41
18 Jun 2010 à 11:41
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.
