Hi All,
I have an excel file that my team collaborates on. Is there a way to allow every user basis his email address or domain id access only to a specific range?
Hi Team,
I have close to 60 rows of data in an excel file for 60 users. I want to send this data to them individually along with the Row Headers.
Attached is a sample file. Can you please help with the same?
Hi Team,
How can I merge the data from 75 excel files into one single file. The column headers are the same & so are the data formats. It is however important to note that the 75 files will be updated on a daily basis
Hi Team,
I have 9148 rows of city codes in an excel file
I need to concatenate these values e.g. below
1) BOM
2) CCU
3) LHR
4) CDG
Output needs to be as
BOMCCU
BOMLHR
BOM CDG
CCUBOM
CCULHR
and so on
CCUCDG
I cant do this in excel since excel will only allow 1,00,000 rows & for every...
Hi All,
Here is a sample of the text that I have
1) Adhesives & Sealants / Caulk, Sealants, & Fillers / Concrete & Asphalt Repair
2) Safety / Personal Protective Equipment (PPE) / Gloves & Hand Protection / Gloves / Cut- & Puncture-Resistant Work Gloves
I need to extract all the data after the...
Damm thats awesome but i made a small error.
I am looking for the output on sheet titled as Ex2 - if any of the terms of sheet Ex1-Yes are present on Ex2 (exact or near match) then it should say Match Found or Match Not Found
for example
Ex2 has Sriram Iyengar
and Ex1- Yes has
Shahrukh Khan...
Hi All,
I have two worksheets. I need to find out if any of the terms present on the worksheet titled as EX1- Yes are present on the sheet titled as EX2 (near match or exact match both).
I tried a vlookup but i don't think that is the solution. Can you please help?
Hi All,
I have a list of Product IDs & a list of URLs. The process I need to follow is
1) copy the URL from my list and paste it into a browser
2) Copy the product id from the same file and do a search for it on the website
3) Copy the URL that i get as an outcome of the search result and...
Thanks Narayan,
If you look at the Charts worksheet there are people who are crossing 100% utilization. I want the >100% section to be in a different colour
Row #F73 mentions the distance between point A & B
The Table titled new earn table mentions a grid.
G73 to AC 73 mention the num of passengers travelling in every class (e.g.
K S Q L N U T M Y)
The Table on the top has the number of miles he will get basis of the class of travel
In AF 73 i need...
Hi All,
I have a range of numbers and need to find if a specific number falls in that range example below. These are the grids in the range
0 - 100
101-250
251-500
501-750
751-1500
1501-2500
2501-3500
3501-5000
5001-6500
6501+
I need to know as to in what category the below numbers fall...
Guys,
I am trying to match two sets of data in different files. I want excel to eliminate the common names. However a twist to the tale is that i want excel to eliminate any similarly spelt names as well. E.G.
Is Set 1 has Sriram & Set 2 has Shreeram - Shreeram should be removed from set 2...
shrivallabha - That did the trick - I only had to make a small change in the formula at the end....
=IF(COUNTIF(E4:E12,"WIP"),"WIP",IF(COUNTIF(E4:E12,"Pending"),"Pending",IF(COUNTIF(E4:E12,"Completed")=COUNTA(E4:E12),"Completed","N/A"))) I changed the last N/A to Completed