I'm trying to create one, "master" table of information, and have some pre-defined filtered versions of that table available in separate sheets (of the same workbook) for easier printing. ...

I have a typical requirement. I came across multiple sources but somehow i dont get the answer for my query. My requirement is, i have 3 columns with item, color, type. Item column contains name of ...

Basically I tried the function CONCATENATE and also tried &, but both are not working. Microsoft Excel is only showing !value#. How to bypass the problem of exceeding 255 characters? Can somebody ...

For the string, "Johnny#-ANF14112-26406TAG8-Bob: Frank Johnny#" I am trying to extract "26406TAG8". The challenge is that the delimiter is not always a "-". It may be a ...

how to AutoFilter Cells with blank background color but have data? What value do I need to pass in colorIndex to get the following results ? enter image description here Sub FilterByColor() Dim ...

I'm trying to find a correct formula for this. I want to find the date if we add the month by 4. The answer should be September 30, 2024, but why the output is October 01, 2024? what should I add to ...

I need help with Excel to display data based on drop-down selections. I have a table with "Name" and "Gender." How can I set it up so when I select "Male" or "Female&...

What is the objective? Pump data into xlsx file from a data source("Data Table" for now). What has been so far? A new XLSX file was created. Columns were added and same columns were also ...

Language: Python (version 3.12) Packages tried: OpenPyxl and Pandas Task: Within a workbook I'm trying to find an instance of a specific year (input) within a column called "Year". From ...

I would like to set up a graphic that is fixed to a cell range. The values there change depending on the data input. If a cell is empty, the axis labelling is still displayed in the graphic. How can I ...

So I wanted to solve a question, which was to compture YoY (Year over Year) growth rate for some specific conditions company, I was given this dataset above and I know the formula of YoY Growth rate. ...

I have excel sheet of more than 1000 item name in which single item contain different sizes (which making sheet long) I want to separate sizes from name and want to put them on top row so that same ...

I want to save an Excel sheet as a file using vba code. That I have achieved. Sheets("html").Select Dim Path As String Dim FileNumber As Integer Dim k As Integer ...

If I have the Seven Dwarfs names as strings in cells H1 to N1 and then select cells B1 to B7, then insert the formula =TRANSPOSE(H1:N1) and then Ctrl-Shift-Enter, then the Seven Dwarfs are inserted ...

Friends, I have a file that when opened, connects to a site and the table in the first sheet is automatically updated (once a day). In the columns after this table, I wrote formulas that perform ...