#filterwithmultiplecriteria

Hi everyone, I am trying to modify a formula that works to take into account which employee made the appointments. The employee name is listed in cell B4 & the column with the employee name is in the range "Income_Artist". Below you can see the mini table version of what I am working on. Any...

Hi Everyone, I recently created a table that counts based on the raw data available. Unfortunately, when I created the formula to find the average, I based it off of a table which already summed up the raw data based on month and year. I would like to modify the formula to find the average...

'This macro will hide all the worksheet except the active sheet Sub HideAllExceptActiveSheet() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets If ws.Name <> ActiveSheet.Name Then ws.Visible = xlSheetHidden Next ws End Sub This code its working But We need 'This macro will Unhide all...

( i was try to making Auto filter data) "When I paste data into a table, the data should be sorted by invoice number, pleased Share to right way vba to possible Tricks"

Hi All, I need help to find the right way to combine "Text Join" and "Filter" function but with multiple criteria: I have tried the text join and filter function combine but only with one criteria =TEXTJOIN(", ",,FILTER($C$2:$C$13,$A$2:$A$13=F2,"")) and the result was "Text 1, Text 2, Text 3...