y/n

Hi all, I'm in a search of a VBA guru. I'd like to turn the following formula into a VBA Conditional Format code: =IF((SUMPRODUCT(COUNTIFS(INDIRECT("'"&Table1[SheetNames]&"'!$D:$D"),$D16,INDIRECT("'"&Table1[SheetNames]&"'!F:F"),"Y")))-IF(VLOOKUP(D16,D16:O16,3,FALSE)="Y",1,0)>0,TRUE,FALSE)...

Hi everyone, Thank you, in advance, for any help! I jumbled together this code which does what I want, however, it is very slow. Could you please help me to identify how I can make this more efficient and effective? I have multiple spreadsheets with similar and different data, that needs to...

I have the sample sheet below. I need to count how many y's and n's there are for each ad week per store. I tried a few different countifs with no luck. Any help is appreciated. <colgroup><col width="22" style="width: 17pt; mso-width-source: userset; mso-width-alt: 804;"> <col width="73"...

Good morning! I am using several Select Case commands to hide different rows under differing circumstances in a macro native to a worksheet. I find myself needing to sum the visible cells which would obviously change depending on choices made in other cells. I am aware that Subtotal will work...

Hi All, I just moved over to Excel 365 and am having issues with Pivot Tables and Row Names for Y/N columns. Below is an example of my data. The output I need is what the total costs for Need and Required are. What I received is either 1) Row for Y and Row for (blank) [does not include actual...

I have Y and N answers in a multiple category spreadsheet. I am trying to pull them into a Pivot Table but, cannot seem to get it filtered correctly. The counts and Y/N are not filtering correctly. <tbody> Filters Columns NONE VALUE Rows Values CORRELATED DATA ALL COLUMNS...