address

Hello! I usually come here for help when I can't find what I'm looking for, so maybe someone can help me. I have a column with cell address: <tbody> $B$896 $F$994 $N$103 $V$961 $AH$509 $AX$222 $BB$1050 </tbody> Now wat I want, is to go automatically trough the list, and place...

I wish to automate the calculation of my portfolio at the end of day for my analysis purposes. https://nseindia.com/live_market/dynaContent/live_watch/get_quote/GetQuote.jsp?symbol=SBIN The above web address needs to be dynamically modified to obtain data of stocks. In the above address "SBIN"...

Hi I want to use vlookup() to return multiple values. User will enter the name in cell G2 and vlookup() will return phone number and address. So I selected 2 cells (I2 and J2) and typed this function G2=VLOOKUP(G2,A2:C15,{2,3},flase) and pressed ctrl+shift+enter But I got error msg #Name ...

How does one go about convert the cell address. I know that the absolute function converts the cell row, column to a cell address such as $a1 how would you convert a range a1:f10 to row and column numbers. Thanks

Is it possible to use the file address that is in a cell in the worksheet instead of actually having the file address in the macro for the file we are accessing to get data from? In other words If I wanted to get data from another file I could paste the address into cell B2 for example on the...

I have uploaded to my Google Drive an Excel spreadsheet - https://drive.google.com/file/d/1JzPo1MSrQO44SOf1SBR6oRdPs34icPp2/view?usp=sharing There are two tabs, ORIG and DESIRED RESULTS. This is just a subset of a much longer file. The goal is to have all lines with the same address on one...

Hi there, i was hoping someone could help me with this query. i have a large set of address data which needs to be cleansed and analysed to find duplication within rows. i have included a sample set of data which hopefully will portray my issues. Hopefully, someone can help. <tbody> Name...

Hello, I have excel sheet where i have huge data. Column A contains vendor code (a number) and column B contains Name of vendor in first cell and Address in subsequent cells in same column B. Number of cells occupied in column B for address is not fixed it can be 2,3 or more. I want to merge...

I am having an issue with finding the correct syntax to utilize the vlookup where two criteria are met if the first vlookup returns no data. so I was thinking something like find host on datatableA, - if there is an address value (not blank), display it; if not, then look for the host {still on...

Haven't been able to cobble together an answer for this from previous questions, thanks in advance to anyone who can help. Example data set follows with question below. <tbody> Group Value OWNRSHP_ID PNT_NO PNT_MATCH ADDRESS_LINE_1 2 500 900 11164 701 Green 2 1.5 70 6019302309 11164 701...

I am looking for a formula to extract the first name and last name in one column in Proper Case from email address below neil.michaels@tnsa.com It must appear as Neil Michaels I have tried using the formula below =PROPER(LEFT(F2,FIND("@",F2)-1)) The result is Neil.Michaels Your...

I have this spreadsheet where I use the below formula to save many, many hours of work. In row 7 is a list of codes that trade on the stock market such as ANZ, BHP, RIO etc. The below formula picks up the code from row 7 and saves me adding a different stock market company code to each formula...

Is it possible to have code that takes a screen-shot of all sheets named with a 5-digit student ID number (eg: 69213) and save that image as a jpeg (named with the same 5-digit code as the sheet the image came from) in the same folder (called ... 2019) as where the spreadsheet is housed ? The...

Hi Everyone! I'm digging around the ole Google world to see if something is possible or if software exists. I current can export a file from a vendor and it contains information that I want to import to another vendor. The issue is the column names do not match so I have to stop and tweak the...

I want to replace the reference of Cell O4 with ADDRESS(4,15,4,1) =CELL("contents",O4) to =CELL("contents",ADDRESS(4,15,4,1)) "=CELL(""contents"",O4)" to be "=CELL(""contents"",ADDRESS(4,15,4,1))"

<colgroup><col style="mso-width-source:userset;mso-width-alt:9325;width:191pt" width="255"> <col style="mso-width-source:userset;mso-width-alt:2157;width:44pt" width="59"> <col style="mso-width-source:userset;mso-width-alt:10532;width:216pt" width="288"> </colgroup><tbody> SHELBERT...

Can't get the formula right. I have two tabs in a spreadsheet with many rows and columns. I need to pull the need contrac t a nd comments from Tab 2 to the corresponding address in tab 1 (which has a bunch of other info in it) Trying to use index match (don't want to use vlookup- long story)...

Hello, I am trying to format some addresses. They are currently "Street Address, CITY" and I am trying to remove the City along with the Comma. Example: 9062 Old Annapolis Rd, COLUMBIA Want: 9062 Old Annapolis Rd I have tried flash fill and while that mostly worked it went wonky on...

I want to set a variable to a range address (C68). when I do Range_Variable =Range ("C68") I get the value that is in C68 no a cell reference (R1C1) that an be used as an address in formulas this is probably very simple but I have not found the answer