All Questions
Tagged with column microsoft-excel
25
questions
0
votes
0
answers
53
views
Excel Discrete column-wise selection from area
I'd like to be able to select an area column-wise (as individual columns). Manually holding down CTRL works fine for a few columns but when you've got 200 to select it becomes tedious. I'd like to be ...
1
vote
1
answer
44
views
How do I indicate nested data groups side-by-side in an Excel stacked column chart?
I am preparing a chart for an academic journal and am struggling with formatting.
In the original chart I am trying to reproduce, nested data for two year periods, 2017 and 2020/21, are displayed ...
0
votes
0
answers
49
views
Excel Sortby formula on alpha numerics e.g. A1 to A100 to return 4 rows of associated data
I have used this formula to sort the column A1 to A100 so that A
=SORTBY(A1:A206,COLUMN(INDIRECT(A1:A206)),1,ROW(INDIRECT(A1:A206)),1)
thanks to one of your posts: Advanced sorting of alphanumeric ...
0
votes
2
answers
100
views
MS Excel Convert column data into row
I have all data in a column in MS excel.
Please see the attached picture: .
I am trying to covert data with its corresponding heading and other data associated with its "Acct No.". as sample ...
2
votes
1
answer
506
views
How to create a stacked column chart where each category has unrelated subcategories
I have the following set of data
I want to create a column chart with 3 stacked columns(one for each category). The sum of amounts for each category equals 100. The issue I'm having is that the ...
0
votes
0
answers
48
views
How do I extract a single list of 3D spatial coordinates across 2 different sheets that link the 3 cartesian planes?
I am using Excel to draw an ellipsoid that is rotated by 15 degrees. What I want is not a 3D plot of it, but I want to get a list of all the coordinates that share a certain criteria. An example is ...
0
votes
1
answer
51
views
Excel Formula that copys Column Title based off related data within row
I am looking for a formula to represent what is in the highlighted section of the excel sheet. For example, for invoice 4/1/2022, i would like a formula for "payable for" that lists (1)...
0
votes
1
answer
319
views
How do I use a cell reference as a column in a table reference?
Say I have a table "Data" (created with the "Format as table" button, with headers). In another table (say "Table"), I have a column ("Target column") that has ...
0
votes
2
answers
865
views
Split one excel column with data separated by comma into many columns
I am using a program called FilterPro to design an electronic filter. The filter has some associated data, which you can export to Excel. In FilterPro the data looks like this, where they use a ...
0
votes
1
answer
57
views
highlight row with different colors after date is entered in different column cells
We have a spreadsheet that tracks items by date in different columns. Item sent in column L, we would like it to be one color. but once the second date in entered column R. I am needing the row to ...
0
votes
0
answers
61
views
How to fill a column getting a substring of another one with a rule
I'm trying to play with the functions LEFT, RIGHT and SEARCH to fill a column with the name of a function extracted from another column, but I don't get any good result.
I have a list of functions ...
-1
votes
1
answer
53
views
Mixing 2 columns in excel
Good Morning
I'm trying to "combine" two columns in Excel. Not concatenating them, but "mixing" the result
For example, I have these 2 columns:
Column 1
Column 2
a
1
b
2
c
3
...
2
votes
0
answers
81
views
How can I set the column width on a given column in multiple opened Excel files at once?
I have 10 opened Excel files. Each of them contains one spreadsheet. How can I set the column width on a given column in multiple opened Excel files at once? I use Excel 2205 on Microsoft Windows 10.
0
votes
0
answers
88
views
Excel - How to combine columns (without concatenating them) from multiple files
I have multiple CSV files, each containing several columns, but only one of interest, column B. It's a column whose header is "Results" and each row in the column contains numeric data.
For ...
0
votes
1
answer
68
views
Pivot calculated field of variation
I want to create a pivot graph that shows the variation (%) in number of road accidents from year to year+1. I need it to be pivot because I want it to be refreshable if data change.
My data is a list ...