situation

  1. T

    Can't find the ampersand character in a character string

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

    Using If statement in cell based on two adjacent cells

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

    Lookup Field

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

    VBA Create Email Links

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

    Other presentation articles

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

    IF 11:00 PM, do nothing. otherwise do this...

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

    negative to positive matching in a list

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

    3 check boxes - all are check senior

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

    Assign formula

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

    Need all but one blank row deleted

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

    Formula Fill to Begin at the False Statement

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

    Mystery Data Table

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

    Code Really Slows Down Sheet

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

    Count without duplicates

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

    Workday Help

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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top