situation

Hello, I'm using Excel 2016 and am trying to find the ampersand character (&) in a cells that are just characters. There is no = at the beginning of the string. Something like Victory & International. I've googled for that and didn't find anything the pertains to my situation. So, how do I...

Hello All, Here is a question, I have a situation where i have a column "AD" that displays a date. The date listed should be 1 year from the date shown in column "AC", unless "N/A" is noted, then it should list the date for 1 year from column "AB". I really familiar with vba but i don't want to...

Hello, Is it possible to have a field on a worksheet that can serve as a lookup for an ID that I can pull the related data from another sheet? If so can that data be protected when the data is completed like in an invoice situation? I appreciate any advice or help, XJ

So the table below spans columns A-G <tbody> Situation Date Originating Agency Lead Assisting Summary Email List 1 Jan 1 TCHC ODSP TPS Summary goes here emai1@email.com 2 Jan 1 TESS EMS TCHC Summary goes here emails@emails.com </tbody> I have a button that creates email links in column H...

Who knows how I can change the presentation of articles data? We have a very big data file with this (some rows have more columns than others). I refer to below for an example of the OLD data situation and the NEW situation presentation. Who knows the formulas or the things to do in Excel...

Newb here so bear with me if the answer is obvious! Situation: Working on a real life business situation where we are looking at current store operating hours and deciding if we need to close early if we are doing less than $40 in sales. I can write the formula for that - no problem...

There is a situation for which I am looking for a solution I receive a lot of data in an excel sheet, Let's say in column A and these are receipts(positive amount) and payments(negative amount) and these net to zero except few I already use a macro which matches positive to negative for...

Hi I have 3 checkboxes in a sheet. I liked them to cells k2,k3, and k4. I created if statement, please see below. The only problem I have when use check more than one boxes. My if function does not handle this situation. I want to send a message saying "One box has to be selected at a time" How...

Hello guys, Cant solve this function, so decided to write here. Maybe you can help me. Situation: Have a huge list (like a 30k+ rows). in A Column i have Numbers and in B i have Names. Basically i get a random list of names and i need to assign a exact number from list. Example: My...

First of all, this is my first post so bare with me. I have been playing around with macros for Excel and have been able to find pretty much everything that I need. The communities are great and appreciate that there are so many willing to helping one another out! Kudos to all! My situation is...

Hello All,I am trying to solve the following problem. in Cell D1 I enter this =if($A1=0,B1,B100) When I will fill the Formula down it changes to b2,B101 & b3,c102 ... What I am trying to accomplish is the false fill down to begin when it encounters the first fall situation. Assume cell A5 is the...

Hi. I have a file which a colleague worked on a bit over the weekend, and excel is now under the impression that the file contains a data table. We keep calculations set to manual, and now when i press F9, i see Data Table: 1 in the status bar for a second or 2 while the file calculates. The...

Ever since I added the following code to my sheet (which is activated by a button), the performance of my sheet is A LOT slower. Are there any ideas as to why? Thanks in advance for the help. Sub insertVeryLongHyperlink() Dim curCell As Range Dim longHyperlink As Variant Dim x...

Hello everybody. I've a situation like the following: column f column g A ONE A ONE A TWO A THREE A THREE B ONE B ONE B ONE B TWO A FOUR A FOUR A FOUR A FOUR A FIVE I need a formula that counts how many differents values in column g for the value A in...

Hello I need to generate a list (A1:A23) of working days (excluding weekdays) for the current month. I am currently using =WORKDAY(startdate,1,) with the startdate reference is in F1, but in that situation the A1 starts with the second working day. example: if I put 1 November 2017, Wednesday...