diff

Hey I am new here, just joined few days ago but I am working on a task to perform text diff, on a detailed scale to cells in a column (comparing previous and current versions). Working on the core function of text diff with string formatting to highlight differences (strikethroughs for deleted...

Hey Guys, I cant figure out how to create a visual that shows day over day data with a 7 and 14 day volume change on the most recent date. I already created a measure to calculate the 7 and 14 Day difference, but when I put it into the matrix, it does the calc for each date..... Here's what I...

I have a file Sum.xlsx with link form soure =D:\OneDrive\OneDrive - FTT\2019\Stock\[Summarize.xlsx]TAA'!M5 I saved this Sum.xlsx and then I open this file and file link changed to ='https://ftt-my.sharepoint.com/personal/user/Documents/2019/Stock/[Summarize.xlsx]TAA'!M5 I used onedrive for...

i'm trying to learn a few new reports at work. one of the things i need to do is based on a pivot table. i've been able to create the data just fine but i'd really like to make it look like the previous person who did this. i can't seem to find a way to see all the formats applied to a pivot...

Sometimes when I'm on a worksheet I'd like to know which cells here pull in data from an outside source, whether it's a diff tab within the workbook, or a diff workbook altogether. Is there a way to do this? Finding all cells which are formulas is simple enough. I just do a search for the equal...

I have following data <colgroup><col><col><col span="6"><col></colgroup><tbody> TRANSROAD - 01/06/18 JOB NO: PORT CHARGES USD APPROVED DIFF TSHS APPROVED DIFF REMARKS TR-0418 KALONJI - P/C 76 76 -...

<colgroup><col><col><col span="6"><col></colgroup><tbody> TRANSROAD - 01/06/18 JOB NO: WHARFAGE : USD APPROVED DIFF TSHS APPROVED DIFF REMARKS TR-0506 BALLEYA ENT - 6,694,028 6,694,028 TR-0446 S.F ENT -...

<colgroup><col><col><col span="6"><col></colgroup><tbody> TRANSROAD - 01/06/18 JOB NO: DELIVERY ORDER USD APPROVED DIFF TSHS APPROVED DIFF REMARKS TR-0381 TESCO - DIAMOND 85 85 - - $ 2000.00...

Hi Friends, I need the output as shown in column D(Expected Diff) with basic If calculation. Logic should be simple not much complicated as I will use the logic in some other tool for performance consideration. (Left, Right and Mid should be avoided if possible). Any thoughts ...

A B C 1 1/2/17 Meals $50 2 2/2/17 Office $100 3 Other $200 Sum C1:C3 IF B1:B3 AND IF A1:A3 occurred in 1(January). The answer should be $50. It should ONLY SUM C where B says meals (B1) and A says "1" (A1). I have tried some...

Is it possible to save a file to multiple locations EVERY time someone amends it? At my office we share docs and 6 people can edit the same doc. I want to be able to create a backup of the file to a diff folder every time someone makes a change and saves it. It has to be a diff folder because...

<tbody> A B C D E F G H 1 name Start time End Time Actual Hrs Straight Shift Diff OT Shift Diff OT 2 02/24/2018 06:10 02/24/18 18:40 12 12 .7 3 02/25/2018 06:10 02/25/18 18:40 12 12 .7 4 03/02/2018 06:10 03/02/18 18:40 12 12 .7 5 03/03/2018 06:10 03/03/18...

A B C D E F G H Name Start End hours worked Straight Shift Diff OT Shift Diff OT MR A 02/25/2018 06:10 02/25/2018 18:40...

Hi, I have a diff column that is comparing current month and prior month value. Depending on type of the values in current month and prior month, the diff column either does CM - PM value or =CM=PM to see if the text value has changed MoM. I have conditional formats on the diff column. Here...

Hi, I have a spreadsheet which lists students, their instructors names, actual hours of teaching and a calculation (diff). I need to be able to do two things: 1. Create a summary for each instructor which counts the number of times each instructors time is over 0.2 (in the 'Diff' column)...

<tbody> A B C 1 Point Eastings Northings 2 1 567768 6376890 3 2 567702 6376035 4 3 567835 6377836 5 4 567936 6376471 6 5 568035 6376044 7 6 566834 6377837 8 7 567413 6378635 9 8 566036 6378999 10 9 568634 6377941 11 10 566345 6376534 12 13 14 First Point 15...

ok so I have my file that some cells are multiline cells... I want to separate the multi line cells in the next column... for which I have this code: Columns("A:A").Select Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote...

I have two tab-delimited text files I'd like to compare. They're lists of products. The purpose of the comparison is to discover if any new products have been added to the list. Here are two samples from March 13th and 15th: tta20140313.txt 775111882 2014-03-15 05:10:11 HD 10.99 604125993...

I have two worksheets (Sheet 1 & 2) where column A on both worksheets has a list of codes. Some of the codes are duplicated on both worksheets. Some codes are unique for each sheet. I would like to create a DIFF on Sheet 3, Column A, that lists all of the like codes from sheet 1 and 2. On...