1. H

    Cross Tab Query How to Get Distinct Values

    Hello everyone, This is my first time posting just as an FYI. I am trying to make a cross tab query that shows Location as the rows and Week Number as the Columns with a value set up in builder. Where I'm running into an issue is that in order to get the accurate value, I need the distinct...
  2. M

    Cross reference cell values then copy data between sheets

    This one is a bit difficult for me to explain, so i included screenshots to help....maybe I've have to cover some of the data as its personal information source<source <source (separate="" worksheet) destination<destination<destination...
  3. C

    Moving Axis Cross Points automatically within Excel 2010

    Hi everyone, I am hoping that somebody will be able to help me as I haven't been able to figure this out on my own or find the answer anywhere on the net yet. I am in the process of creating a data dashboard for data reporting at work. As part of this I have created a document that allows...
  4. R

    MAXIF and return another column

    Hi, Please can somebody help? The purpose is to get the Max of column C for each AssetID(column B) and then return whether it’s a Cross Arm or Pole but I’d need to returnall values for Poles and Cross Arm if the highest occurs more than once per AssetID. So just for the below example, the...
  5. M

    if statement for +/- a percentage

    Hello, I'm trying to display a tick or cross in F if a variance (D-C) is less than or greater than C but i'm having a total mind blank. Should be easy but its not! I've got the wingdings side easily just the formula is stuffing me around So Num1 ...Num2 ...Variance.....Mark...
  6. John Caines

    Insert a formated tick-cross into cell-vba

    Hello All. I have a spreadsheet with about 450 cells that need to have a tick or a cross inserted into them. I've found a great bit of code here; which is 80% of what I would really like the vba to do,,, code so far...
  7. M

    Power query - cross join - net discounted cash flow

    Dear all, Question. I have a table with contract start dates and contract end dates. I want to cross join this in power query with a table containing all months from 1/1/2019 to 31/12/2039 which are potentially the months in which payments can be done under the contracts. Is there a way in...
  8. U

    Can the default Cursor in 2016 be change back to an Arrow?

    I can't seem to find anywhere how to change the Plus or Cross sign (pointer, cursor) back to just a plain ol Arrow. Does anyone here know if it can be done. I want to make my pointer stay as a default Arrow instead of a cross when I'm working on my spreadsheets. Thanks in advance if you come...
  9. P

    Sum - Index, Match, Match

    I am having some trouble using sum with Index, Match, Match. My Formula is =SUM(INDEX(Sheet1!$B$1:$R$50,MATCH('July 2018'!$B10,Sheet1!$B$1:$B$50,0),MATCH('July 2018'!$O$2,Sheet1!$B$1:$R$1,0))) I need to cross match two categories and where that information meets up, I need to sum. Thanks
  10. D

    Creating new rows via a cross reference

    OK guys, be patient with me as I try my best to explain what I need in a way that doesn’t make me look like a raving lunatic. (I might be one, I just don’t want to look like one). OK I am open to any solution that works in Excel or Access (including SQL statements) because I really don’t know...
  11. S

    Cursor changed from arrow to cross

    This is crazy. My colleague opened a file and now her cursor is no longer an arrow but shows as a cross similar to the cursor one gets when deleting a text box. A real stumper. I can't find an option to change the cursor. Any ideas? thanks Steve
  12. D

    Merging 2 worksheets using the data from 2 columns

    Hi, I'm a bit of a newbie with Excel. Please could someone help me. I have 2 worksheets, sheet 1 and sheet 2, and I want to merge the matching data from sheet 2 onto sheet 1. The problem I have is I need to use times, in column B, and names, in column C, to cross reference with the same data...
  13. T

    How to highlight cross point of two lines in a graph?

    Hi all, I am sure it has been asked before but I can't find it in the forums. I made a line graph with two lines A and B Line A will cross line B where this is is depending on the values that create A and B I want to mark this cross point with a dodand the text "payback" How can I make this...
  14. E

    Macro to lookup date, name and place data into it

    Good morning all of you, This is my first ever post in this forum and I am sincerely stuck on this on for the last week... I am looking for a macro to lookup cells B2 and B3 in calculator sheet which are name and date and cross referencing in a productivity spreadsheet determine the cross cell...
  15. A

    Two columns & cross fill input

    Hi, I have a spreadsheet where I have column A and column B. In column A I want a price with V.A.T (=B1*1.25) and in column B i want a price without V.A.T (=A1*0.8). What I mean with that is that if I enter a value in column B I want Excel to automatically fill in the value in column A. And...
  16. muhammad susanto

    Alphabetic Series...

    hello all.. how to make this below code it works : =char(code(e11)+1) a cross post any helps is greatly appreciated. m.susanto
  17. L

    Cross Table Dinner

    Hi guys, maybe one of you can help me. And please apologize, I am german living in SouthAmerica, so my english is limited and I might not be able to express myself as good as I would like to ... patience please ... I am organizing a Cross Table Dinner, you might have heard about this. In a...
  18. max_max

    cross posting

    Hello everyone. Is it possible in this forum for cross posting? max_max
  19. max_max

    correction formula given increase every 2 months

    Hello everyone. Is it possible in this forum for cross posting? max_max
  20. M

    Conditional formatting with Icon Sets

    i am trying to compare two rows of numbers and use conditional formatting with either a tick or a cross if the two values are the same or not. for instance in cell a1 the heading would be predicted cell b1 the heading would be actual cell a2 would have 2 cell b2 would have...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...