numbers

  1. Dazzawm

    Remove Everything When Numbers End To Adjacent Column

    I have numbers as below. When the numbers end I want everything removed to the adjacent column. I cant use text to columns as there are varying lengths etc. So a code or formula please. P.S Some may not have letters etc after numbers for example WA2345 Before Excel 2010 Row\ColAE...
  2. A

    number to percent format

    hi, i am tring to conver number to percent but its not happening its showing as numbers please help me out this and also i want to aply a condition if based on percent if above 50% the cells should be red and for DIO if its > 30 days it should be red when i am tring in F8 its working but when i...
  3. C

    Split Collums by Category

    Hi everyone, I need the example below to look like the example right of the arrow. I only want to take the Ashleigh data and all the numbers under Ashleigh and have that data to the side. Can anyone help me understand how to do this?
  4. N

    Template for staffing numbers

    Hi i would like to design a spreadsheet with my staff in the first column and time across the spreadsheet. A coloured bar across the weeks would show when that staff member was available. The bar would be blank when they were on leave. This would visualise the numbers of staff numbers available...
  5. R

    Disreguard #N/A when adding a column of numbers.

    I have a column of numbers that come from a vlookup. I want to add this column up skipping the cells with a #N/A result from the vlookup. Thanks guys.
  6. H

    Extract data from a list using criteria

    Has me stumped. Column A: Fault codes (3 digit, multiple instances in random order) Column B: Unique serial number of part that has the fault in Column A. Data is continuously being added to the table. I want to use a formula to extract the serial numbers in column B into columns unique to...
  7. K

    How to reduce betting blokes that can guarantee max 1 incorrect

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> Here I have a question how to reduce betting blokes that can guarantee max 1 incorrect, what I mean this, for example "Euromillions" playing 8 numbers direct we are playing 56 lines it cost 140€ "Formula=COMBIN(8,5)" if out of 8 numbers 5...
  8. J

    Find missing numbers and post.

    Hello everyone and thanks ahead for your help! I am using Excel 2016 and in my spreadsheet, in column A starting in cell A1 I have sorted numbers from 1 to 1000, no duplicates and no blank cells and no data beyond last number. There are however missing numbers. I would like Excel to when I...
  9. danhendo888

    Text Formula to show commas only when > 999

    Suppose I have two numbers 8170.5999 618.111 Is there a formula that shows them as: 8,170 618 That is, show a comma when over 999 I used TEXT with "$0,000" but this shows the comma even for numbers below 1,000
  10. H

    How to detect missing numbers within a list?

    I have a column of serial numbers that are randomly classified. Is there an option in Excel that detects the missing numbers within this list? Thank you NUM 4001 4003 4004 4005 4006 4007 4008 4009 4010 4011 4013...
  11. M

    Lottery Bingo

    So i have a list of say 10 players down column 'A' To the right of these names there are 6 numbers ranging from 1-59 in separate cells (columns B, C, D, E, F, & G) Somewhere else in the spreadsheet, i want to put the recent lottery results (drawn twice per week) which will consist of 6 numbers...
  12. A

    Having trouble making diagram

    Hello all, so I want to make a diagram, but would like it to be like spiderweb or something. It is interconnecting and comparing diagram. so example A1 b1 c1 d1 e1 1 7 4 5 2 2 8 10 11 3 3 3 A1 d1 4 6 B1 5 9 6 4...
  13. I

    Regex to replace dashs between digits

    i am in the need for a regex for my vba project. i need to replace the - dash that is in-between numbers only, example 1-3-1. The problem is i have negative numbers with dashes which i need to keep, but the patterm is consistent, 1-3-1, should be 1,3,1 so replace dash between digits with a...
  14. N

    Excel Formula

    Hi, Is there a way to extract the numbers from the cell. For example: A1 <<<<< Manikandan S Natesan (17.09.2019-12:48:31) >>>>> 9161995548 9161995551 9161995552 9161995553 <<<<< Shanmugapriyan Malliraja B1 I need the numbers starting with 91, which is 9161995548 9161995551 9161995552...
  15. JTL9161

    Sumproduct/Match

    I am having a brain block. I have 4 columns with number and label. a1:a30 are numbers, b1:b30 are labels. C1:c30 are numbers, D1:D30 are labels All in random order. I am trying to match the labels in column B to the label in Column D and then add the 2 numbers corresponding numbers in column...
  16. L

    hiding only +ve numbers

    Hi I have the data below and I want to hide only positive numbers. So I went to Format Cells --> custom and typed ; I thought that would ignored the +ve only since I did not write anything for the positive. I know custom format is like this positive; negative; 0; text so ignoring positive...
  17. T

    Sumproduct and offset issues

    Hi, I managed to have certain cells of my sheet1 reference others from sheet2 If a condition was met by using sumproduct. I managed to get this reference by using offset as I wanted to automate it by having it index numbers every 4 columns. it went smoothly while I was using no column offset...
  18. T

    Issues using Sumproduct with Offset

    Hi all, I'm having issues with a file I'm working with. to make it brief. I'm trying to get data from a second sheet (1) into my main sheet (2). the second sheet has data of budget spent every month for a range of work numbers, the total spent (which is the figure I want) is every 4th column...
  19. M

    SUMPRODUCT Blank Cells with LEFT & RIGHT

    Hello, I'm looking to use this formula =SUMPRODUCT(LEFT(G3:G100,2)+(RIGHT(G3:G100,8))) with cells that have numbers in but some in the middle are blank. If I try and return it at the moment, I get a value error due to blank cells. How do I get it to skip blanks? I don't want to shorten the...
  20. M

    Formula for a number in a range appearing in another range

    Hi, I'm hoping this will be a pretty simple one for all you experts out there. I have a range of 5 numbers and I just need a formula to give me a yes/no or true/false for if any of the numbers appear in a different range of 5 numbers. For example: Range 1 is 1,2,3,4,5 Range 2 is 7,8,9,10,1...

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