similar

Hi, A simple one really but what is the best way to highlight similar values in a column of numbers? Regards

Hi, firstly I'm not sure if the title explains very well my issue so I'll explain what the function needs to do. I have two sheets with numerous columns on, some similar, some not. On my first sheet I need to look up the value in A1 for the similar value in the second sheet but I need to look...

Hi all, Since learning about IF functions, I was successful in writing a nested IF changing 50 values for a different (but similar) 50 values. Is there a better way that you could direct me to research please. Thank you.

Hello Everyone, I found macro which allow to automatically update my old value. But i have the similar problem like: user: jqfanco https://www.mrexcel.com/forum/excel-questions/1036624-data-validation-updates.html Anyone can help me with this issue? I will be appreciate for your help

I would like to have a certain range visible or hidden. Similar to entire columns/rows, but only the range. Let's say B2:F10 Is this possible? Thank you,

Hi everyone, Need help with a formula. In cell range A1:A365 I have the numbers 1 through 365 In cell range B1:B365 I have the dates. Most recent date in cell B1 March 1, 2019 In cell B2 I have the same date March 1, 2019 Cell B3 = February 28, 2019 Cell B4 = February 28, 2019 etc. etc...

<tbody> Custody 50 Transaction 70 Revenue 1000 Custody/Txn ? </tbody> I'm trying to modify one of my formulas. Essentially I want to write a SUMIF statement where anytime it sees either Custody or Transactions it adds them up. I think it'd be something similar to this...

Hi folks tried this: Workbooks.Open Filename:="\\FS01\1300Shared\Marketing Folder\scorecard.xls" Error: Sorry we couldn't find \\FS01\1300Shared\Marketing Folder\scorecard.xls. It is possible it was moved, renamed or deleted. Also doesn't work using the Drive letter Workbooks.Open...

Hi, I am making a spreadsheet where I want to note if 2 dates are greater than 7 days. For example: <colgroup><col><col><col></colgroup><tbody> Received Type collected 2/20/19 swab 15/02/2019 21/02/2019 swab 12/02/2019 </tbody> I have been using: =IF((A1-C1)>=7, "Old"), and a few other...

Hello, I'm in dire need. I need the median values for a set of data, using the pivot table functionality. Is there a way to use the pivot table tool to determine this, similar to how I can quickly identify the average, sum, min, max, etc? Thanks so much!!!

Hi, Does anyone know a Formula / Function that is similar to CONCATENATE but don't need to individually select values? Thank you.

Hi, I'm new here. This is the situation: In my office I have 2 pc with very similar configuration. 16 GB ram and similar CPU (I7 4790 vs I7 6700). When I try to update, or simply put or remove a filter on a column the performance is very different. For example, If I insert a filter on a column...

I have a data set with a few hundred addresses. I'd like to make a chart similar to this: https://ibb.co/z4SPrwC Can I do this in Excel?

Hello All, I have multiple worksheets pulling information from one worksheet which is an imported database dump from another team. The dump consists of data similar to columns A & B. All other worksheets are similar to columns D thru G. I can gather the required information for each sheet...

Hi I currently send invoices via email using excel. I use gmail and the process works extremely well. My question is - can I use a similar logic to send text messages? For the email process I reference CDO - is there something similar but for texting from a range of telephone numbers? Many...

Hi team, I was wondering if someone can help me with an interesting lookup issue I am having. I will receive a file that will be similar to Tab 2, out of which I need to build a view similar to Tab 1 below (I have manually filled in the numbers, to show what those cells should read). I tried...

Good morning/afternoon/evening, I work for an Insurance company and i'm running into the following problem: I'm trying to standardise 'free-text clauses' in our insurance system, clauses for insurance products which, for one reason or another, were not entered using a standard clause...

I have a formulae in an Excel cell that looks at a text string and returns a code dependent on the found text. I am having to a add a similar code to one already used and have an issue with the result. The formulae is :- =IF(ISERROR(FIND("-SL",$C$4,1)),"","SMT...

Hi guys, I'm trying to figure out if i can have a formula that will put the first value from column B in column G for every similar value in column C. I have a file with testdata uploaded here: https://www.dropbox.com/s/cehp2rmi5ao5tta/Testfile01.xlsx?dl=0 So basically the column Route (C)...

Hi I am reading about 3D formula. I found that it does not come with any new idea! It is very similar to Data Consolidation (Data-->Consolidate), am I right? if yes, then why I have one another? Thank you.