provide

Hi all, I need some help figuring out a formula to read two columns and if they're both filled, then to provide the data. Example: I have one worksheet that serves as my data dump. Column C is a list of customers and column J and K are the brands of computers and smartphones they own...

Hi everyone! If A1 has the text "Cement" then it should calculate and produce result in A5 like this (A2/105*100). A2 will have some numerical value. If A1 does not have Cement then A5 should show 0. Please advise and provide a formula for the above request.

Hi everyone, I am trying to sort the following data into the combined data following. I can't think of a way to do this and have been stuck for quite a while. Basically the goal is to list the numbers in the first column separated by a space, followed by the unique columns. Any tips...

Good morning all, this is my first post so please be gentle. i have been asked to help build a new system to log the quotes that we provide to our customers and i could really use some help. so far i have designed it so that all of the information is entered and then there is a hyperlink...

Hi all, Hope you are well and thank you in advance for taking your time to read my post. Not sure if it is at all possible, i have a pivot table with slicers and would like to restrict the information end users can view based on a password I provide them. e.g. the pivot table will contain...

I'm using =if(d3*e3/f3+g3<>0,d3*e3/f3+g3,0) Isn't there something similar to iferror(x,0) - that simply returns x as long as x is not an error. A number of times - I need to test if something meets some condition and if it does I just want that value returned and if not I want a zero - but...

Hello I use a combo box (form control) to cycle through a list of employees. When I click on one of the names a statement pulls up their information and I am able to print them. In the past I have just gone down the line and clicked each individual name. The amount of names has increased and I...

I'm new to this so bare with me. I have an excel sheet with data on it in columns B-G. The amount of Rows with data will vary, beginning from row 6-?, but always continuous, no rows will be empty. I would like to click a button and have checkboxes inserted in columns H,I,J only on the rows...

Hi all, Hope someone will be able to help. I am below beginner with VBA and what I'm trying to do is starting to frustrate. I have a form for a customer to complete. When a number < 5 is entered into a specific cell I need a pop up to come up saying "Please provide key improvement" This would...

Hi, Was wondering if anyone could take 5 minutes to review one of my spreadsheets. I have completed it to a good standard but was wondering if any one could provide feedback? It's not very complex so doesn't require a genius, although any help would be great! Thanks,

racking my brain trying every various combinations of formula, but using the following general setup have the user provide a "name" and a "skill" and have formula return the three most recent dates and corresponding grades. Biggest problem i have is that the raw data is in the format that the...

Hello: I want to write a vlookup statement but I also need to combine it with a if then statement I believe. This is what I have COL C has a list of codes. I am Vlookup against these codes. Using the codes listed in COL C I am going to pull data from COL V (port) Using the codes listed in...

This is driving me crazy because I have instructions to do this, but no matter what i do to try and resolve it nothing is working. I've googled this issue and apparently others have had the same issue, but was never really able to get help. I know somebody from community will have experienced...

Hello I am trying to find a way to assign 6 different values to a cell based on numbers that were entered in another cell. So for example: in Cell D2 someone would enter either 1, 2,3,4,5 or 6. I then want Cell H2 to automatically put a 10 if there was a 1 in D2, a 6 if there was a 2 in D2...

Hello, I need to remove the leading zeros in column J. It would need to remove from alphanumeric strings. Can some one provide the VBA code to do this? Thanks!

Hello All, I need some help with the following: I have a list of codes in column A in which some are repeated. Then I have specific codings across the top horizontally that are individual, but will not always be in the same order. I need to be able to pull the sum by matching both. I'll...

I figured out how to get my bookmarks out of Firefox and into Excel. A macro processes them, and other macros get you around the Worksheet. It uses: 1.) Firefox, 2.) SQLite3, 3.) DOS, 4.) Excel VBA, 5.) NirCmd (optional) All you have to do is to categorize your bookmarks, and then click the...

I want to say thank you for clicking on my post and and thank for any help you might be able to provide. What I am trying to accomplish is for an old BBS that I help assist run. I am trying to provide helpful information for the small user base that still continues to play. Attached below is...

I have the below table. I need a formula that will sum Row 1, but only provide the sum for the cells that do not have a value in row 2. So I need the Sum on Row 1 in this circumstance to equal $80 (Because there is a value in A2, E2, H2, & L2...therefore not adding cells A1, E1, H1 & L1 to the...

Hello, I need to look up certain parameters on another table and have it provide a result. I cant even insert a table to explain, bad start. Can you help? <colgroup><col><col><col></colgroup><tbody> </tbody> <colgroup><col><col><col></colgroup><tbody> </tbody>