purpose

I am trying to create a formula: I want the formula to do as follow if cell A2 = any number for example 100 then cell B2 will equal 1 <tbody> 100 1 110 6 115 9 </tbody> the purpose of this is to match the database with license numbers and ranking based on those license numbers...

Am looking for, but cannot find a explanation for the role of the number one in this function: =IF(A2>1,A2+C2,"") Column A contains dates, 01/01/19 Column C contains numbers, 13,16,20,21 The end result if a calculated date. But, I was not told what purpose the ">1" in the function serves and...

Hi All, I am using the following code, but unfortunately it is not giving the result I want: Dim model As String, Purpose As String, Replaced As String model = Sheets("General Data").Range("B9").Value Purpose = Sheets("General Data").Range("D5").Value Replaced = Sheets("General...

Is there a way to embed multiple workbooks each with their multiple sheets into one workbooks where the tabs would correspond to the inserted workbooks. Clicking a tab in this workbook would open up a workbook and not just a sheet. Seems very handy and general purpose. Joe

Good day, I need either a function or macro that will give me the last numeric value of any column of data. I have read the threads related to "=LOOKUP(2,1/(A:A<>""),A:A)." However the above limits me to column A and I don't have the skills to change it to give me what I need from other columns...

I have a file with 1331 account ID's, I can use the count function to identify if an ID is duplicated, is there a way to identify which of the duplicates is the primary duplicate? For the purpose of this, the primary would be defined as appearing first in the order (row number)

It seems some data I am working on is too much for excel to handle. Yes I am limited to Excel 2010 32 bit for the moment, mainly due to those who will be reviewing the data are restricted to to this. I have about 300K rows, I have removed all special formatting, and have turned into a table for...

Hi, Suppose I have some data in A2 C2 & E2. In F2 I want to put a formula where it shows that if any one of those three separate cells (which is not in a range) contains a blank then show X in F2. I could do it with multiple nested IF functions (=If(A2="", "X", If(C2="", "X", If(E2="", "X"...

Hi people, I come across some similar posts but not able to modify it to my purpose. In column C & F has if function, D&E has sum function. The formula in C:C is =IF(AND(M4>=3,N4>=2,O4="wait"),"wait",IF(AND(M4<=-3,N4<=-2,O4="close"),"close","-")). These values in D,E and F keeps changing for...

Hi How you can replace Cells with Range in the following code. I want to use Cells instead (for learning purpose). Thank you. Workbooks(1).Worksheets(1).Range("D1:f10").Interior.ColorIndex = 11

Hi, Applying FILTER in a table which included name of retail outlets and their town names. At bottom of table somewhere in a cell for a purpose I want to show "filtered" town name while apply filter on a town ... and my purpose is... I will put a "vlookup" with this to pull data from another...

pointtotal is a named range. Trying to understand the purpose of the 3 in the scoring formula. thank you =ROUND(100-pointtotal/3,0)/100

Is it possible to obtain a timeline slicer value in a cell ? or even better yet to use in a Footer ? I am only using slicer on a Monthly purpose and would like to format to see as January - 2018 Thanks

I wrote a macro to do a certain task whenever I receive an email. So how should I apply that in outlook to fulfill the purpose of the macro ? Thank You.

Hi Do you know where I can find a website/files etc which has assignments and solution in different subject, school/college style? for practicing purpose. ExcelsFun has assignments but not for education purpose and I can not find what is the question is. Thank you.

I personally never used this program before in my life. So if anybody can be so kind to summarize what the purpose of this program is for, I'd really appreciate it. Thanks in advance

Hi I want to fill a column with random names (e.g. John, Alex, Mary, David etc) instead of typing them manually for education/study purpose. Is there anyway I can do that? Thanks

I have one worksheet name measurementIdentity where I want to count preexisting combination (column D,H,I and J) for each Cell (unique value of column C) and band (Column K). from audit list result you will know which condition is preexisting and which is extra and which is missing. I have more...

Hello, I was wondering if I could get some help please. I am attempting to reformat a large set of data to load into qlikview. At the moment there are multiple columns with values on one line separated by a comma. I would like to find a way to separate the data for all of the columns. I have...

Hello All: Hoping you can help me with this problem: Date Vendor Purpose Amount Auto Books Dues Entertainment Ground Transportation Office I need to populate the fields after Amount with the contents of the Amount cell based on the Purpose field, for example 10/20 XYZ Books 50.00...