xyz

<tbody> Name Serial Number Date Price Address Comments A 1 1/1/2019 123 abc xyz B 2 1/1/2019 123 abc xyz A 3 1/1/2019 123 abc xyz C 4 1/1/2019 123 abc xyz </tbody> i have data that looks like this, i am trying to load this into an array and populate a new array with the data...

Hello, I need some help with finding the most efficient formula. This could have other questions that lead after this but my first issue is below. Tag 1 and Tag 2 are my end results i need to come up with. So if the Tag column has an "MP" in the beginning, then my Result 1 will equal the Tag...

Hi excel expert, is there any formula taht i can use as per data below: Before <tbody> A B 1 abc xyz 2 3 4 5 6 7 8 9 </tbody> After <tbody> A B 1 abc xyz 2 2 6 3 4 abc xyz 5 abc xyz 6 xyz 7 xyz 8 xyz 9 xyz </tbody> when i put...

Hello How can I get a list of Data Name Range from the following representation ? 1. Columns are fixed (A:D) 2. Rows are unpredictable: TableDataName Range is also unpredictable 3. Data Name Range to be named from Firms Name ie from COL A which is hilited in bg color for...

I have a portfolio with hundred of stocks, but for simplicity, let's say I have three stocks, with their respective PERs and market caps: <tbody> PER Market Cap ABC 15 150 DEF 10 101 XYZ 12 80 Market-cap-weighted average 12.99x Formula ? </tbody> I would like to take a...

I have a series of Columns containing employee names from my company directory. Column A is the Requestor of the respective row's project (several more columns containing project info). Columns B-D contain the next three managers in the org chart. <tbody> Requestor Manager Manager's Manager...

Hopefully this isn’t too confusing… I have two spreadsheets containing several thousand rows each and need to compare the two. The first (AV) is from our internal database and the second is from an online source (XYZ). AV contains: Name, Email, Phone, Status XYZ contains: Name, Email...

Hi All, First time I am coming to this situation were I don't have any idea how to write a macro for below situation. 1) Unique id is in Column B. 2) Amount is in column C. 3) date of transaction is in column A I need a macro which will add the amount based on unique ID and create new rows...

Hi All, Greetings!! I want to compare column A and column B with Column C and column D Column A data should be compared to Column C and value of Column B with Column D and return which are not matching <style><!--table {mso-displayed-decimal-separator:"\."...

Hello, I am new at creating Loops in Access. I want create a new column for each new occurrence of a ID using a loop. If there is a better way to accomplish this I am open to ideas. Below is what I want to accomplish. Table A <tbody> ID Exception Id Exception Date ABC 55576 7/4/19...

hello, must be having a brain fart... can't get a formula to work. I need to take multiple part numbers and pull in all the AVLs that are tied to each one. See example below... so in cell A2 I would have a part number XYZ, XYZ has 4 approved manufactures. So I would want to pull in all the...

I have data that can be duplicated but will need to return specific serial numbers. In one tab i will have the following: <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> Name Model Color PO ABC 123 White PO123 ABC 123 White PO123...

Hi, I have some addresses that need to be split into three different cells: Adress, Zip, and City. I tried =TRIM(LEFT(SUBSTITUTE(D2;",";REPT(" ";LEN(D2)));LEN(D2))) to get the address, worked fine for those with the form: xyzroad 16A, 1400 townXYZ. But when I have it in the form XYZ, XYZroad 18...

I have some data that I need to find out what the total for the lbs used for each day equates to? Thanks in advance. <colgroup><col span="8"></colgroup><tbody> 4/22/2018 4/23/2018 4/24/2018 4/25/2018 4/26/2018 4/27/2018 4/28/2018 Lbs used Cases 5,000 9,000 7,000 8,750...

Hi, I am trying to create an additional column (field/item/calculated?) in a pivot table to show the difference row by row. My data is like this: <tbody> Customer Date $ ABC Jan-18 50 ABC Jan-18 50 ABC Feb-18 75 ABC Feb-18 75 XYZ Jan-18 125 XYZ Jan-18 125 XYZ Feb-18 150 XYZ...

Hello There! i am working on a project where i have been given 1200 files and all i have to do is to copy paste the data from 1200 file to 1 file under the given column headers(Headers are the same in 1200 files) i have already written a Macro to resolve this, it works fine in terms of copying...

<tbody> Sr No Name Recept Date Stock Used sent End Stock 1 abc 1/4/18 120 10 10 100 2 xyz 2/4/18 100 10 90 3 abc 5/4/18 100(auto) 4 xyz 10/4/18 90(auto) </tbody> Hi Need to set a formula which calculate the end stock(post consumption), however the present stock should...

Dear Friends, I have few words like the following: * ABC LIMITED * ~~TIN : 58976532147 * XYZ (P) LIMITED * ~~TIN : 25648793251 I want to extract only ABC LIMITED & XYZ (P) LIMITED Pls provide me a formula. Regards RAMU

Hello, I have data in cell ref A1 which look something like this. .. Abc def 47 so a formula in cell B1 should output value = Abc def and similarly in cell C1 output = 47 more examples:- A1 = Abc B1 = Abc C1 = A1 = Abc 5 0 1 B1 = Abc C1 = 501 A1 = 50 0 B1 = C1 = 500 A1 = Abc 50 40...

Hy, I have a text looks like: "abcdef | 123456 | xyz" I need to show only the last few character after the last " | " character, (delete everything before the last " | " and the pipe character too) so in this case i need: "xyz" (the number of the characters is different all the time) Oh, and...