All Questions
708
questions
-2
votes
0
answers
47
views
what is the best excel function to solve this problem? [closed]
sentences
email
name
name
email
date
sentences1
solution1
sentences2
solution2
sentences3
solution3
you are beautiful
Jack
non@gma
01/02/2024
sen37
blabla
sen4
blabla6
sen8
balbla11
nice one
Jessy
...
-3
votes
0
answers
47
views
I have a databese with product in excel over 4000 products and i want to filter excat product as i type uniq specification not showing simillary
I want an excel formula to filter the data as soon as I start typing the product specifications and not show me products with similar specifications but only show the product I type. If I write 0.9×50×...
0
votes
0
answers
32
views
VBA - Search & Display : result doesn't take comment/URL into account
I've been working on a dynamic search bar in Excel, following this video, and it works fine.
=IF(I3="","No match",FILTER(Table1,ISNUMBER(SEARCH(I3,Table1[Sujet])),"No match&...
0
votes
1
answer
62
views
Search and highlight a row in an Excel sheet which contains two or more different data
I want to query based on the values in different cells in an Excel sheet and color the rows where these values are located at the same time. The current code just colors a single line and the loop ...
0
votes
2
answers
57
views
Excel: How to extract a certain word, from a list of words, from a range of cells?
I'm looking to extract the varietal type of a wine, from a list of wine names. There's no formatting consistency. I've got a list of 8 potential wine types (shiraz, rosé, chardonnay, etc.) and about ...
-1
votes
2
answers
156
views
Can I use =isnumber(search( function on multiple columns at the same time?
I have a table where I have to check row by row that the org name, work country and location refer to the same country.
In the below table there are a few examples where the last 3 rows are incorrect, ...
0
votes
2
answers
68
views
Excel: Is there a way for me to use formulas to return the value in a cell using a specific type of two-step search in another sheet?
Suppose I have an Excel file with multiple sheets, and on the main sheet the user can type in a year and a name. I would like to create a formula that returns a code assigned with that name under that ...
0
votes
2
answers
211
views
Excel: Search for strings while excluding others within individual cells
I am hoping for help. I am doing a veterinary pathology study on a large group of cases. I want to check a group of cells on a row separately for inclusion of a string. For the most part it's ...
1
vote
1
answer
22
views
Excel VBA search for data and stuck at a certain point due to group or split source file?
I have below code which quite simple maybe not the most elegant but works well with a small mistake what I cannot handle. Source excel file is something which I am using with group and split in 4 on ...
-1
votes
3
answers
115
views
Importing a value from closed workbook
I'm sorry in advance, I just don't know how to word my problem well.
I work with information of surveyed trees that is stored in excel. I have had some success using VBA macros to import the data ...
0
votes
0
answers
43
views
Search in multiple Excel files (by values) containing same sheets and give information for range
I have several Excel files in a folder. Each contains the same Sheets, with similar data for companies.
These are data on medical examinations of employees and documents, both of which have expiration ...
-2
votes
1
answer
62
views
Value Look Up based on Multiple Criteria from the same table's rows and columns
I want to create a formula in Columns E and F that will determine who are the agents and nurses on a particular CALL type ROWS.
Example:
I have 2 calls in this sample (Call IDs: 12345 and 67890). They ...
0
votes
2
answers
66
views
Excel search function problem when trying to display only certain columns
[Office Professional 2021]
I have an Excel workbook made of 2 sheets:
--1st sheet is named Database_locale and it had a table that has data from column A to column L and this database is updated every ...
1
vote
1
answer
41
views
How can I search a range of multiple rows and columns for a value and return it's header?
I would like to create an excel function that allows me to return a header for a row of data that contains a search value.
In the example attached, I'd like to be able to return which group each ...
-2
votes
1
answer
115
views
Request for improved vba code to execute a query in excel
would greatly appreciate any help to improve my macro. I am new to vba and, although I found a solution for the scenario below, the code seems to be extensive especially when my goal is to be able to ...