Search results

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?

Thank you so much for your quick assistance. I tried to execute the macro but get the attached screenshot.

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...

Awesome - Thank you so much

ADPP@BH.. Sorry this is the password to be used

ADPP@BH is the password. Of the 300 files 84 files have different passwords (The password for these 84 files is either ADQAPP/QAADPP

Hi All, I have 12 password protected files and want to merge them into a single file. How do I do this.

Thanks Haseeb !!!

THANKS !! That helped. Is there a similar formula that i can use if I need to extract the data between any of the two "/"

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

Guys, How do I change the colour of a single bar on excel. I need the part greater than 100% to show in Red Post Moved by Mod

Oh my that worked !!! Thanks

I tried but it seems to be throwing up a #NA error

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...

Awesome !! Thanks Somendra

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...

I thought as much but it sounded like Chandoo read my mind. The homepage has a VBA macro that can be used for the same. Hoping to make some headway

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