cross

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

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 https://imgur.com/cFDqyS8 source<source <source (separate="" worksheet) https://imgur.com/jdC0Ii9 destination<destination<destination...

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

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

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

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; https://www.extendoffice.com/documents/excel/4558-excel-tick-and-cross.html which is 80% of what I would really like the vba to do,,, code so far...

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

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

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

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

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

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

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

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

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

hello all.. how to make this below code it works : =char(code(e11)+1) a cross post https://www.excelforum.com/excel-formulas-and-functions/1208807-fill-alphabetic-series-with-interval-row.html any helps is greatly appreciated. m.susanto

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

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

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

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