attached

Hi everyone, I am trying to have the user select a range to input. I have been able to have set a parameter for the number of columns selected. I can not figure out what line would show error if the columns selected did not have data. Current code will be attached below: If...

Hi Everyone, Can someone help me out on the below .. 1. I have 3 tables in sheet1 with the headers from A to F column. 2. I need to name a cell name as "Type" if my next cell name contains as "Data" which will appear anywhere from A to K however i need to repeat the same step for Table 2 and...

Hey Guys - i need to get the specific cell value if the answer is "NO" can you help ? pls see the snap shot i have attached and as per that. B3 should have C3 value instead of "NO" https://ibb.co/eHHO79

Make all possible sets Hello, I am looking to get all-possible sets of the 14 numbers are listed in the A1:A14 Example attached <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead> A B C D E F G H I J K L...

Hi Folks, Here is my question . 1) If i select the drop down list either Offshore Reject or Onsite Rejected or client rejected in the attached sheet in column H2 i want the entire row from A2 to H2 should be formatted with Yellow fill color and the font should be RED. 2) If i select the drop...

I need to create a graph just like the one shown in the picture i attached. it does not need to have the curve, rectangular bars would be fine. but the axis should be the same. I cant figure out how to make it in excel. If someone can explain, it will be helpful. Thanks (link to sample data in...

I have drawn a chart in excel using tabled values and these values of course were the coordinates by which the graph was drawn. But each certain series on points represent a certain thing called "ρ" (Refer to the attached picture to understand). Then i want to enter the graph with certain...

I am very familiar with conditional formatting, however this situation presents a different kind of obstacle for me. I need a script that will change the cell to the left,right and below etc, a different color if a condition is met without being attached to a cell number designation(A1 etc...)...

I am familiar with vLookUP and I can't search multiple criteria when using vLookup. So I assume I need to use Index to achieve what I want. In the example attached, I would like sheet one to look through the submissions in sheet 2 and tell me if an opening Checklist, Closing Checklist, and Dough...

Hi all, Please see the document attached. I basically need to figure out how to do the percentages. Thank you. EDIT Correct link: https://www.dropbox.com/s/gkqmefowfaxoirk/Version%202.xlsx?dl=0

Could you help me to fix the macro of the attached file to make it work again? Thank you https://www.dropbox.com/s/ltqbn3wg4028qif/google_results.xlsm?dl=0

Dear excel experts. I am in a situation where after exproting some data from old database some vlaues are missing in such a way that cell 1,2,3 and 4 in a column should have same value. but cell 1, 2 and 3 are blank while 4th one has the value. How can i copy the value of every 4th cell in...

i need some help , but here cant attached file or local image so i give a link . https://www.excelforum.com/excel-programming-vba-macros/1233216-excel-vba-how-to-use-macros-to-return-the-match-value.html#post4911438 Thanks!

Hi, I am looking for a solution for the following. In the column on the left I have different article numbers, each article number has one or more (up to 20) Sales Orders attached to it. For each article number, I would like to see the sum of all Sales Orders attached to that specific article...

Hello, I'm struggling with a formula which has way too many nested IF functions. The goal is to create a priority list for the IFs. To explain further - I'm trying to extract a unique identifying number (henceforth #) given a set of conditions. The conditions are: If # is attached to...

Hi everyone, I'm re posting this as my previous thread was a bit confusing and didn't get any replies. I would like column D:D to be populated with a function rather than manually. This column contains H codes taken from E:E. The codes are in this format: H0xx-H9xx (4 characters, first...

Dear Friends Can anyone please help me to protect my print range in attached sheet. In attached sheet, I have selected range from A1 to G49 for printing but some of my team members can change this printing range and then print. Can anyone please help, how to protect it...

Hi, I'm a bit rusty on the old Excel, and can't get my formula to ignore the blank cells as per my attached example. https://expirebox.com/download/c89685e8e2a4a9399fd5bfb474bf3e97.html Any help here would be greatly appreciated!! Thanks :)

Hey everyone, I'll go straight to the question. I am currently working on a construction schedule for work and I know there has to be a way where I could simply what I am doing so please any suggestion will help. Please look at the attached image. PS I couldn't find the button for upload so I...

Hey MrExcel. I have ran into what I consider to be a rather complex problem. I have millions of lines of data that I need to merge into a single sheet, however it is not as easy as simply copying and pasting the columns next to each other as intervals are missing. I should mention that case...