6 questions from the last 1 days
0
votes
0
answers
15
views
Return each unique combination from 2 columns and return other information from the same row
I have a tool I am working on using the latest version of Excel (whatever it is) and I have a table which looks like this:
I want to take each unique combination of values from the Code and POBox ...
- 25
1
vote
2
answers
42
views
How to check if two cells in the same column contain matching text in Excel?
Is there an Excel formula that can detect whether two cells in the same column contain similar or partially matching text?
For example:
F3 contains: "regulation BI, how to stop exploitation"...
1
vote
2
answers
59
views
Problem creating cell output from Date using VBA script in Excel
I'm trying to use VBA to insert a new row and then create a reference using the date in the format yyyymmdd followed by a hyphen and then 1.
So for example, today I would like the output to read ...
- 11
-4
votes
0
answers
42
views
Fetching Data online [closed]
I have a website which is handled by customer and uses that to display customer status about his medical fitness report.
Everyday we have 40-60 clients that we send data to the customer, if I want to ...
Advice
0
votes
5
replies
77
views
Excel conditional formatting: how to format entire RELATIVE columns based on single row value
My question is quite straightforward - or at least, it should be!
I have an Excel sheet with dates and weekdays laid out across the top three rows. I want to highlight all columns in a particular ...
- 1,516
-5
votes
0
answers
73
views
Reading multiple Excel files with multiple worksheets in R [closed]
I have to read around 80 Excel files with multiple worksheets. They are questionnaires that are all formatted the same way and where there is one column for the question, one for the question_id, one ...
- 1