#dynamicranges

Hello All, So today my boss told me that he wanted a just a cell that displays YTD YOY growth. So essentially here is what we're working with for excel tables. Year January February March April May June July August September October November December Total 2017 $ 16,186.00 $ 20,262.00 $...

# 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 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

I have dynamic name range named "Employee" defined as "=offset(Sheet1!A1,0,0,counta(Sheet1!A:A)-1,1)" I want to make this name range as input range to my combo box. When I enter the input range for the combobox as "Employee" (without the quotes) it gives me an error "Reference is not valid"...

Hi, I am looking for away to use a dynamic range for an advanced filter that will update the "list Range" based off of a drop down list. For example, i have 4 worksheet for the months of Jan through April. I need the advanced filter to look at data in a specific sheet based off a drop down list...