Count cells with multiple criteria like COUNTIFS() but still get the functionality of case sens.??
How can I count cells with multiple criteria like COUNTIFS() but still get the functionality of case sensitivity? In other words I need something like this: =COUNTIFS($C:$C,"<"&DATE($AB$5, 11, 1), https://twitter.com/search?q=%24C&src=cashtag_click:$C,">="&DATE($AB$5, 10, 1), DataReport!$E:$E, "*"&"LA"&"*") =COUNTIFS($C:$C,"<"&DATE($AB$5, 11, 1), https://twitter.com/search?q=%24C&src=cashtag_click:$C,">="&DATE($AB$5, 10, 1), DataReport!$E:$E, "*"&"La"&"*") https://twitter.com/search?q=%24AB&src=cashtag_click$5 references a cell that simple states the year 2019. Notice that I want two different counts here LA and La within the month of Oct 2019. If I could find a way to make this case sensitive then I would work perfectly. How would I go about doing something like this? Thanks in advance.
Help with assigning account codes to one table from another table
I'm trying to find and assign account codes for monthly accounting books I have for my business. What I'd like excel to do is search for text in a column ("Name" column shown below) and, if specific text is found in a cell ("Text field" column shown below), return the account code from the table on the right with the specific text. Please see image below. Is there a function I can use to automate the process of assigning account codes to various expenses?
