xcel

  1. F

    Horizontal Conditional formatting not working as expected.

    I have used the following formula =AND(NOT(ISBLANK($A4)), ISBLANK($E4)blank. to conditionally format a blank cell, when a neighboring cell is not blank. It works as expected, however when I have tried to use the same formula on another sheet, the reverse happens. AR highlights instead of e4. A4...
  2. M

    Can Get This Excel File to Be Recognised

    I am trying to use the USA example file for this. I can't get the program to recognise the file for the charting package even though I am following the instructions. I get this warning: The selected file type does not support workbooks that contain multiple sheets. I can't even see the mutiple...
  3. A

    why is this file so big?

    https://www.4shared.com/photo/f0Q3CCCyca/FILE_SIZE.html https://www.4shared.com/rar/eP0V5IQ_ca/TAX_2017.html i dont know how to upload excel files i put them on a shared thingy so you can download them. i have a 5 column - 50 row spreadsheet. please tell me why it saves at 15MEG !! it is now a...
  4. P

    Very long macro!!

    Hi Mr Excel gurus. Am "surgically" preparing to come up with JUST ONE LONG MACRO, recording >20 sequence of events to "cut out" tedious manual repetitive tasks. Wondering the problems I may encounter recording & running it. Anyone who has successfully created & using a long Macro? My...
  5. E

    Help with data population

    Hello! I am having trouble figuring out how to take the data from one sheet and create and populate other sheets based off of that data. I have 200 books on a master list, and I am trying to add those books Title, Author, and Series number to a template that I made. One sheet for every book...
  6. S

    Vlookup To subtract Order Qty From Supply and Mark additional Cell

    I am relativly new to VBA. I am in need of some code that will assist me in looking up information on a sheet (Orders) from a sheet (Supply) and subtracting the order value from the supply value. If Order Qty < Supply Qty and the deduction is calculated I also need it to place an x in an...
  7. N

    Count occurances of random number groups

    Hi Everyone....Can anyone please suggest a formula in Excel 2003 which can be used to count the number of occurances of random number groups in a column? A group is classed as 1 or more numbers that occur consecutively. An example of the data (each number in an individual cell) is; 2, 2, 5, 5...

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