#filter

Hi Everyone, I am trying to figure out how to find out when a client on my clientele list first visited our shop. Below is a sample table to give you an idea of what the clients list would look like and the date format that I am currently using. ABCDEFGHI1Client NameDatePaymentUnique...

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...

( 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...

All Question And Answer to save in "Sheet1) We Need Reference "Question" Sheet1 to Sheet 2 , Also need four Option reference data from Sheet 1 According Question Kindly make solution this query

# HOW TO MATCH "HSN CODE" AFTER PULL DATA ON DIFFERENT-DIFFERENT TABLES ??? We need pull data into different- different Table . Kindly Help on solve my Query, Kindly Send us Proper formula , - perfect match " HSN CODE" And pull data from TABLE1 , send to matching table

My Formula Problem this above condition , Not show Proper Format We Need this Format Result : EXP/025/21-22 Kindly Correction Below Formula , and Show Perfect Formula in this case =LEFT("EXP",3)&"/"&MID(A2,5,3)&"/21-22" Help me !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Between two Slashs "/" Or Two and more Slashs how to work formula in this condition

How to match Same number via join data NOTE: Not use this formula ( =+C3&" "&D3&" / "&C5&" "&D5&" / "&C6&" "&D6) WE NEED THIS PERFECT FORMULA IN THIS QUERY

@ How to make One Dropdownlist , Including all table Column Cell Details Show ???? without Dependent Dropdownlist ??? How to show dropdownlist using different -different Columns data , And Add Included Single Dropdownlist ************************************************NOT USE DEPENDENT...

(NEED THIS CONDITION) C2= "20 ft" use 5,00,000 C2= "40 ft" use 10,00,000 Change value According "20 ft" Or "40 ft " ------------------------------Kindly Suggest Right Formula-----------------

HOW TO USE REFERENCE WITH "RIGHT OR LEFT" FORMULA FUNCTION ???? EXAMPLE: i Try this Reference "AB156480" =+A2 But I need Output : " AB156-480" How it Possible After reference ????

Hello everyone! :) I need to develop a macro that sums cases and packs (units) quantities from an exported file. The final document has the below aspect: Cases Units Week Cases dispatched Cases forecasted Cases ordered Units despatched Units forecasted Units ordered 35 7517 7794...

Hi, this may sound easy but i'm new to vba so i don't know the exact syntax to use... I want to loop throught all Textbox in a userform and wanna perfom a specific command if they are empty or not... the boxes are all named TextBox1, TextBox2, ... so I wanna have acces to the value in it and...

Hello I am very new to Power Query so please bear with me. Can someone help with a basic question? I have used the Power Query editor to filter a column. It shows: #"Filter CLASS"= Table.SelectRows(#"Uppercase CLASS", each ([#"CLASS"] = "Chemistry" or [#"CLASS"] = "Physics") I would like...