obtain

I need to know how to write the following: =IF(3rd digit in cell J2="2","2-10051","1-10031") I do don't know how to obtain the 3rd digit. I tried researching this and tried several ways but got "error" or "false".

Is there a way to obtain/calculate (or approximate) the "Available Memory" Number shown in Task Manager using VBA? Thanks.

I am trying to obtain the name of a named range passed to a UDF. I want to use it in error messages. Based on previous discussions and an Internet search, I came up with this, which doesn't work. Public Function ShowRangeName(rng As Range) Dim rngname As String rngname = rng.Name.Name MsgBox...

I am receiving the error "unable to get the vlookup property of the worksheet function class" on the line below. Set sampleSet = Application.WorksheetFunction.VLookup(sampleVar, TblRng, 2, False).Address I suspect there are a few problems with the way the line was written. My overall goal...

Hi All, I have a vertical list from A1:G1 John Fred Alex John Tim Fred John There are also values in B1:G1 next to those names which are irrelevant. For the second "John" I need a formula to search the vertical list above it (from bottom to top), find the first "John", and obtain the value...

Hi, Trying to modify the code below to allow the direct use of cell references instead of popping up an InputBox. I've tried e.g. Set tags = Range("B2:I2") but this isn't working. Also wondering why the code below works with Set used only once rather than at the start of each line? Dim...

Hi, How do I write a code to replace cells that contains "0" in column A with the word at the top row of each 0 group? <tbody> AD 0 XX 0 XX 0 XX 0 XX AC 0 XX 0 XX DE 0 XX </tbody> Above is sample table and below is the output that i wish to obtain. <tbody> AD XX...

G'day! I currently have : =SUM(IF(FREQUENCY(A8:A1000,A8:A1000)>0,1)) It batches column A with re-occurring values and gives the number of batches this works great! However, I now want to look at column H:H and see how many batches from A:A have the value "MG" in column B. See example below...

If I have data like this, pre-pivoted: <tbody> ID Q1 Q2 Group 1 Explore Not at all 1 2 Personal Somewhat 1 3 Take Very 1 4 Obtain Very 1 5 Obtain Very 1 6 Take Not at all 1 7 Personal Sucessful 1 8 Improve Successful 1 9 Obtain Very successful 1 10 Obtain Not at all 2...

Hello everyone, thanks in advance for your time. I've got this problem: 1. I have a list of almost 24K ID numbers. 2. I have a table with ranges, saying: "from ID #1.000.000 to ID #2.000.000 was born in 1920"; and so with another 65 ranges, saying from this ID to that ID was born in this...

I would like to direct, by way of a MsgBox, the user to select a pull-down cell and obtain a selection and then continue the program operation. How and what VBE coding will accomplish this?

Is there a way in a worksheet (without using VBA) to obtain the name of a range, if one is defined? For example, suppose I have assigned the name "HeaderRow" to $7:$7. Is there a way for me to obtain the text "HeaderRow" if I provide the row number (7)? The Address function doesn't seem to do...