numerical value

  1. S

    Pivot tables using an external CSV file is pulling numerical data through as text

    Good afternoon, I have to run large reports from a system so I generate the output in csv format. In the past I would run a pivot in excel using SQL to pull in the data from the CSV. Recently the source system has been upgraded. Since then, if I open the pivot I can see numerical data as...
  2. cata2200

    Numerical value of a colour

    Hello all I'm looking for a function/formula to get the numerical value of the background colour of a cell.:confused: Thanks Catalin
  3. D

    How do I make my Macro stop copying the title row too??

    Hi, In my macro, I am copying and pasting a value, this is the code: If Cells(i, 7).value > 0 Then With Cells(i, 7).Select Selection.Copy Cells(i, 9).Select Selection.pastespecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    • Replies: 49
    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
    • Replies: 40
    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
    • Replies: 35
    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
    • Replies: 35
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    • Replies: 30
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    • Replies: 25
    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