All Questions
28
questions
1
vote
1
answer
987
views
Excel: How to search for values from a column within a cell that has comma seperated values
I have one column with text in seperate rows, and a cell that has comma seperated values within the singular cell, as below.
One
Two
AB
AB, EF
CD
...
I'd like a formula to return True if any text ...
- 13
0
votes
2
answers
207
views
I have two cells each with comma delimited values, I want to combine these into one cell
I have two excel cells(A1 and B1) each contains comma delimited values in, I want to combine these values into one cell (C1), so that the first value from cell A1 is "linked" to the first ...
- 1
0
votes
1
answer
1k
views
How to insert filename from cell into excel formula?
I have a bunch of .csv files that have IDs that I am trying to insert into a formula. The IDs are all listed in column F. Here is F in my sheet:
F
701
684
128
701
485
701
...
Each CSV file is in a ...
0
votes
1
answer
23
views
Incrementing values when values changes in different column in excel
i want to change values when id values changes to different in excel
like this
ID
ChangedId
8
1
8
1
8
1
22
2
22
2
25
3
Any help will be thankfull.
1
vote
1
answer
1k
views
When importing a csv into Excel(2016) is there a way to specify which data should be column headers?
I have a csv file
user1,Donated,460
user1,GiftedT1,137
user1,GiftedT2,205
user1,GiftedT3,144
user1,Cards,123
user2,GiftedT2,123
user2,Donated,123
user2,Cards,123
Is there a way when importing the csv ...
0
votes
1
answer
511
views
How to automatically sum columns datas of a grouped row subset with common attributes (excel csv spreadsheet)
I have a big csv file (one million rows) I imported in excel.
I have to do a simple operation, easy to be done manually, but I should do it for thousands groupings so I am looking for an automated ...
- 3
1
vote
1
answer
381
views
Excel is adding = in front of cells containing @ mark when importing from CSV
I'm not sure why, but since a few days ago when I import a .csv it is adding a "=" infront of cells which begin with an @.
It should be like this:
But now it is doing this:
I've compared all ...
- 71
1
vote
4
answers
19k
views
Get unique values from a comma separated values in a cell
In excel I have a column (actually multiple columns with ~30K rows) with each cell value looking something like this
7AA914BC, 898B70FB, 898B70FB, 15DD4C5B, 15DD4C5B, 98D2185E, 898BAC48, 98D2185E, ...
- 13
1
vote
1
answer
148
views
Certain Time Values in a .xlsx not Changing When I convert to a .csv
I am trying to convert from an Excel spreadsheet (.xlsx) file to a .csv file. The software I am using is Excel 2007. The issue I am having is I have a column of date and time values for every hour of ...
- 13
0
votes
0
answers
164
views
How to export excel file to csv file without the semicolon outside the inserted values?
I have inserted values into excel file in "order_status" sheet. These values are shown in below picture:
In this sheet I added data validations like: dynamic drop down list, checking if in cell is ...
- 113
1
vote
2
answers
5k
views
How to use values from imported CSV in Excel formulas?
I have an Excel 2016 spreadsheet that uses a CSV file as a data source. I would like to use conditional formatting and formulas to visualize that data more easily.
The problem is that formulas and ...
- 1,271
2
votes
2
answers
6k
views
Convert comma delimited, key-value pairs in single column into different columns
I have a column in an excel sheet that contains value formatted like the following:
"Key1":"Value1","Key2":"Value2","Key3":"Value3"..
I have many rows of this data. I would like to break these keys ...
1
vote
1
answer
259
views
How to sort number of numeric columns in one go
I have 350 columns. Below is a subset of all the data.
I used "Sort Smallest to Largest" tool. It gives results only for one column. If not, it can sort the first column and other columns will ...
- 11
1
vote
3
answers
2k
views
Separating comma delimited data from one cell to multiple cells when the entry is a live data link
My Excel model imports live data from some trading software. If I insert the following formula, I get the details of current tender offers, which are constantly changing:
=RTD("rit2.rtd",, "...
0
votes
1
answer
1k
views
Delete rows in Excel based on list of row numbers
I have a Excel file of names that I am requesting historical testing data on. The list is over 20,000 rows. The system returns a csv file of the row numbers that contain names that do not match. It ...
- 1