xyz

Hi Guys, I've got a lot of cells with useless text and a combination of text + numbers in it that I need and by now I am out of ideas... Sometimes it looks like this: Useless-Text_CD_local random, name (randomname) 2019-10-17T08:20:15 XYZ-COUNTRY-000737 Or like this: Useless-Text_CD_local...

Hello, I have the following look-up formula: =IFERROR((VLOOKUP(AG2,Sheet2!$L$2:$M$617,2,0)),"N/A") I would like to add a condition to this formula that says: IF Column BD = Hello, then return a value of "MK" regardless of the look-up value. Essentially, this logic should override the value...

I have to prepare letter for students of different colleges. For each college, there should be one letter with name of all the students & their details in tabular format. The students data is in excel is as below: <style type="text/css"><!--td {border: 1px solid #ccc;}br...

I have been doing some research but was unable to find exactly what I am trying to achieve. I have been working with VBA frequently but am not quite advanced enough yet to do do this, so I would really appreciate some help! I have a list of customer bookings, with various information and a date...

https://www.youtube.com/watch?v=fRd6wYkfDUQ In this video, Mike uses a list to extract rows from the Start table that DO NOT include anything from the list. Is the opposite possible? If it's in the list, then extract rows from the Start table that contain it. E.g. Suppose the list only has...

Hi, i'm trying to create some subtract formula, but no idea how should i do it, the table below would show the result i desire: <tbody> A B C D E F 1 DATE STOCK ITEMS NAME COST PER STOCK (IN USD) QUANTITY OF STOCKS CUMULATIVE/ BALANCE OF STOCKS REMARK 2 1/1/2019 XYZ USD 1 1000 1000 BUY...

Hi all, Is there a VBA macro that looks to see if a cell has a value? For example: "If Cell(123) has a value then xyz end if" Thanks in advance for the help.

Hi Excel Guru's..need a vba to resolve this. Below table is my Onedrive source Data Set residing in Sheet1 (Table 1 ) <tbody> ID ST NAME Asset Qty UOM Asset2 Qty2 UOM2 Asset3 Qty3 UOM3 Asset4 Qty4 UOM4 Asset5 Qty5 UOM5 Req type Justy Enclose 1 16-07-19 xyz top 5 100 rock 8 80 soft 10 110...

Hi everyone <tbody> Product wholeseller price/kg Apple ABC Rs 50 Orange ABC Rs 30 Apple XYZ Rs 40 </tbody> Using Product as the key i want to extract all the datas in new table like <tbody> Product ABC(Price) XYZ(Price) Apple Rs 50 40 Orange Rs 30 </tbody> I used formula to get...

Sheet 1 <tbody> ABC 40 DEF 25 GHI 35 XYZ 20 </tbody> Sheet 2 <tbody> ABC 45 DEF 20 GHI 10 PQR 18 XYZ 40 </tbody> I want changes in value in 3rd sheet based on name criteria match of both sheet and additional name and value of sheet 2. Could you please solve my issue.

Looking for some help. I'm using this code right now to scrape the innertext of all <li>s on a webpage where the class name is "error' (e.g. <li class="error">, within a DIV tag. However it doesn't work when there is no DIV tag on a page. Can anyone help me to do the same thing, but without...

Hi Team, i have data from col A to L. in my col B i have names abc abc abc xyz xyz xyz xyz xyz and in col A i have 3 different names for "abc" and 5 different names for "xyz", and go on till last record of col B. so i wanted to create workbook "abc" and it should contain their data in that...

Hi all, I have a 6 column running Table (called "CS" - see table below). Each month my macro takes current data from a separate 5 column table and pastes it to the bottom of the CS table. After this procedure, there is always the expected blank 1st column in the CS (which is the "File...

Would like to reach out to this community to ask for help. I have been creating some user forms in Excel but I am stuck when it come to creating user form to enter customer orders. Any recommendation would be greatly appreciated. User Form would generate a SO auto number 1234, however would...

Hi I opened a new file. has sheet1. I clicked on recording Macro. I clicked on + to add a new sheet. Then changed sheet name to XYZ. Then stopped the macro. So far so good, Now sheet XYZ is the active one. I now tried to run the same macro but this time, Sheet3 will be created but then I got...

Hi I have run into a roadblock that I just can't figure out, I would really appreciate any help I can get. On sheet 2 in B2 there is a data validation drop down list that has 6 different options. What I need to happen is that on sheets 6, 8, and 9 for an embedded word doc "Object 1" to be...

In my problem workbook, there are a few things I have to work with but cannot change. The user clicks a button labeled "Enter Job Number" which starts the ball rolling and populates a number of cells in hidden columns A thru E. Once that's done, the user then comes to a button that reads "Click...

I have a workbook name "TCS" I want a vb code which apply on sheet1 It has range A2:A50 and have names in each cell same name files are available on this sub folder; Thisworkbook.path/Backup For example, File name ABC on cell A1 should be hyperlink with file "ABC.xls" in folder Cell A2 named...

Hi All, I have a quick question regarding PowerPivot calculate column. I have below tables 1) Transactions <tbody> EMP ID EMP Name Sale Amount Sale Date Supervisor Name 1 xyz $1000 12/12/18 Sup 1 1 xyz $100 12/15/18 Sup2 </tbody> 2) HeadCount Table <tbody> EMP ID EMP NAme SUp Name...

How to use =SUMIFS for below table in power bi. =SUMIFS(PRIOR MONTHS,REGION,SALES REGION,UI,PID) <tbody style="box-sizing: inherit;"> Prior Months Region Sale Region UI PID Europe Europe ABC ABC 12 Europe Europe XYZ XYZ 12 Europe Europe OPQ OPQ 2.5 Americas...