full

Hello Everyone, thanks in advance! On Sheet 1 in cell A1, I have a can type a prefix (e.g. "CZ1-1123TRH-2200-") and there is a table on a Sheet 2 wherein Column A includes hundreds of values with several prefixes and multiple suffixes for each that create several "assets" (e.g...

Hi, I need prepare offer form. In Sheet 2 i have database with all products and full information about them in row. In sheet1 i have offer(proposal) form. So i trying to make such form, that you can select specific product in Sheet 2 using checkbox and that product with full information which...

I need to see how to extract on the file name from a columns that contains the full path using Power Query. C:\Users\Desktop\Test\PMOD-0001.doc Thanks,

All, I have an excel formula that currently works but is extremely long: +IF('Instructions-START HERE'!$E$12=1,+IF(SUMIFS('Full Data Drop'!H:H,'Full Data Drop'!U:U,'PR HD Upload'!B448,'Full Data Drop'!T:T,'PR HD Upload'!F448,'Full Data Drop'!R:R,'PR HD Upload'!E448,'Full Data Drop'!Y:Y,'PR HD...

I have a full name in a cell and want to convert it to last name first initial only in another column Have: Smith, Mary Want: Smith, M some cells have: Smith, Mary / Jones, Sam Want: Smith, M; Jones, S

I've written a macro that takes the User to a web site; unfortunately it opens in less than full screen. Is there a macro command to expand to full screen ? TonyGreyHd

I have a spreadsheet with a column of formulae, like this example: =HYPERLINK("http...." & C2, left(B2,8)) Now let's say that formula is in cell D2. If I then go elsewhere on my spreadsheet and enter the formula =D2, all I get is plain text of the friendly name (argument 2 of the HYPERLINK...

I have a worksheet named "MINE" and need that when I open it my username appears in cell A1. I need that my username will be full name, example Tony Smith. Thanks in advance

Hi: I have a pivot table set up to display unit price, quantity and totals. I want to show single unit price but Excel is displaying sum of unit price. Data is set up as: Full - 23.50(unit) 52(quantity) and 150 (total) Full - 46.00 Excel is displaying unit price as $69.50 but i want to...

I need a formula to work out number of rolls for X amount of lengths an I can' have part of a length from different roll For example if I have a roll size of 20 metes and lengths of 3 metres, for 12 lengths it is easy 12 x 3m = 36m divided by 20m rl = 2 Rolls The issue becomes when it goes up...

Is it possible to have a picture inserted that is roughly the size of an icon in a cell that opens up to a full sized image? I don't want it linked. If I drag and drop a file from an email, it links to the email. I want to be able to open the picture to see it in full size, but not take up...

Not sure my title is aligned with what I am trying to accomplish. So apologies. I have a table with a column Source HostName (Column G) and for each Source HostName there could 1 to many attempts in migrating that Host. When migrating that host, we either have a 'Success' or 'Error' Status...

Hello All, looking for IF function that will highlight a full row if the cell in that row in column L contains the phrase "Complete" thanks in advance

Hello, I have a formula which has index match combination and it is working ok.There is one problem in that the data sometimes is not exactly the same. For example it is mainly to do with the placement of the full stop. One data source the full stop is placed with a space after the number.e,g...

Hi All, I'm working on a VLOOKUP formula but I'm falling a little short on results. What I'm trying to do is to see if sheet 2's Full Name column is contained (either first or last name) in the Last Name column in Sheet 1. As you can see either the first or last name (or any combo) could...

Hi, I'm trying to find the next empty row in a specific range (A10:A39). If the cell is empty, then the next empty row is selected. I have the basic figured out, my problem is I would like it to ONLY look in the specific range. EG, I do not want A40 selected. Once A10 - A39 are full, I...

Hello, all. Several years ago I watched a ExcelMagic trick that extracted a series of data based on a criteria but I can't seem to find it now. Here is what I need: My data table, currently 2,800 lines long is in an Excel table labled "SpeakerTalks". Column 'A' is labled "Speaker Full Name"...

Hi there, I'm new to the Forum and an Excel novice so I was hoping someone might be able to help with my query! I'm interested to know if a word can represent a certain number in Excel? I have searched the forum for answers to similar questions and seen some responses regarding VLOOKUPS but...

I have a userform that during run time creates 256 individual labels (they represent 5 charts with 53 weeks of data). This works great, I move the axis and scale as needed, I color code them based upon data in the spreadsheets, they have control tips to show their full value.s I also have...

So I am trying to create a spreadsheet to track employee holidays. I have got an idea of how I want it to work when it is finished however, I am having trouble with getting certain aspects to work so this might be quite a long post, and I apologies for that in advance. So firstly, I have set...