Forum Discussion
Need Help!
I have a query. Please help! I have 2 columns (X and Y) with 10 rows each. 1. In X column top 4 rows are blank and rest 6 rows have values. "X" Column Values: [Blank, Blank, Blank, Blank,...
Hello Guavaq,
I can't hard code the columns as column X and Y are actually the month's name and that will varies as the new sales data will be uploaded.
Actual Case, Its quarterly sales data, Month's names are used in columns after pivoting the data. I just need a dynamic function in which I don't need to hardcode the column name as that would be changed in next quarter.
Hi gaurav1991
You could possibly do this with a function.
Do you have some sample data or sample images to see what you are trying to achieve?