xyz

Hello, I would really appreciate some help. I have a spreadsheet with 19 columns. In column A there is a generic code In Column K there is another generic code In column D there is a quantity A D K (qty) ABC 1 123 XYZ 2 123 DEF...

Dear Excel Masters I have Excel data where we capture team working data .basically agent attend the calls and resolve the problem . now I need to calculate how many hrs they are free and what time working window is 9Am to 17:30 Pm Monday to Saturday Thanks Ananya <tbody> Agent In Time...

I have pickup values from 40 different tables based on the a particular value. For example, If my value is ABC then I have to pick the value from a the table specific to ABC, and so on. Each table have 2 columns (one date and one value for that date). These two columns are same across all 40...

<tbody> Name - Column A Date - Column B abc 01/17/2018 12:09:00 AM abc 01/17/2018 12:08:00 AM abc 01/17/2018 12:07:00 AM abc 01/17/2018 12:06:00 AM Xyz 01/17/2018 12:09:00 AM Xyz 01/17/2018 12:08:00 AM Xyz 01/17/2018 12:07:00 AM Xyz 01/17/2018 12:06:00 AM ASAF 01/17/2018...

Hi All. My maths has never been great :-( Just wondering if somone can help me out here, Just looking for a simple calculator that can return % gain/loss, and value in £'s Here's an example of layout of what the calculator would look like. =============== Item xyz Values Buy Price 0.07 Sell...

Merry Christmas to you all, Upon making a selection choice from a combobox list ive got it to fill cells with the correct info but need an image to also be shown in the Imagebox. The data being entered into a specific cell is also the same name as the Image. So if i select from the combobox xyz...

Hi, I am trying to search for text in column A and once found, then search for text below that point. The following does find the first text XYZ but the second find does not limit it's search to below XYZ line. What am I doing wrong? With Range("A:A") Set c = .Find("XYZ")...

Hello everyone! I have a little problem. I need a formula to show the last month for specific company. So for example for company xyz what is the last month that items were sold and then on for company abc. Between columns Month and Firm is also amount sold in original dataset. Does anyone have...

Hi guys and gals. So I am having trouble coming up with a solution to my problem. The scenario I have is an auto populating form based on one key cell. I select the serial number and the rest of the form fills out based on that selection, all of this work fine, until I get to the point that I...

Dear Experts, i wanted to create a timetable in which i only have to insert "x" in a cell and it will automatically insert "xzy" 10 cells to the left/right of where i have entered "x" is something like this possible ? here an example of what i mean; i just need to insert x and xyz will be...

I am a small investor in Shares/ Stocks in Indian Share Market. I have used excel to create stock portfolio. I have bought a few quantity of stocks of Company XYZ at various dates, at various prices and in various quantities. For profit calculation for tax purpose, I am required to use “First...

Hi guys, I have a question, if I have two tables: Table 1 <tbody> 133001, 133002, 146203, 171001, 171003, 171010 ABC 190456, 194782 DEF 190022 XYZ </tbody> Table 2 <tbody> 133002 171001 194782 </tbody> I would like to do a some sort of vlookup using column A Table 2 to return...

Hi I want to write a formula =sum() and select cells from different file as an argument to this function. Lets say I have the formula in a file called ABC.xlsx and the data in another file called XYZ.xlsx. I noticed that to do that I need to open both file in the same excel session (program)...

Dear Friends, Please help me to solve the following task: DataTable <tbody> A B C D E F G H I K SomeName xyz xyz SomeName xyz xyz xyz xyz MyCell SomeName a xyz ? xyz 12 SomeName xyz ? 23 ? 3 ? 52 ? 85 SomeName Z ...

I have a long list of following cells: A11: XYZ A A21: XYZ B A31: XYZ C A41: XYZ D My desired Output: A11: XYZ A B C D Please help me in to find a function or formula.

I have a long list of following cells. e.g. cell A111: 9.03% XYZ investments Ltd. MD(23/06/2019) A451: 7.52% ABC industries ltd.MD (12/02/2020) A600: 8.56% XYZ investments Ltd. MD(45/05/2030) A750: 7.52% ABC industries ltd.MD (12/02/2025) and so...

To be honest, I don't even know how to explain this fully in words, hoping the table will illustrate the dilemma. I have a data validation list in column F, with the appropriate selection made in cell E2 e.g. "white" in table 1. Table 1 <colgroup><col style="width...

Hello! I tried a prior thread which alas did not fully work out (more on this below), but I am still struggling so here goes. I have this large dataset for analysis that has several columns (subject, age, gender, protein, peptide, intensity). I've just made a minor representative subset...

Hello! I've been bumbling around on google trying to sort this out myself, but I am struggling so here goes. I have this large dataset for analysis that has several columns (subject, age, gender, protein, peptide, intensity). I've just made a minor representative subset below. I'm trying to...

Hi All, I have run into a wall on a data base I am trying to complete. I have a mass of data but I am primarily working with 3 columns that will finish up my workbook. For the purpose of this question I have scrubbed erroneous data. I have cell A with Name, cell B with Serial to Name and cell D...