## Placing Specific Amount in Excel Column

Hi, I want to place amount mentioned in particular column into next respective columns based on months provided. Eg given below Amount End Date …

Hi, I want to place amount mentioned in particular column into next respective columns based on months provided. Eg given below Amount End Date …

Develop a formula which will prevent a breach of stay condition in a foreign country which limits your stay to12 months in an18 month period. Assume an example …

Dear everyone, I have a question about the VBA Excel code I am using. The code I use below is a code for adding information from other sheets to the …

Hey, Trying to generate a formula that will choose one variable based off the following rules. Basically, there are 4 variables – a,b,c or d. X …

My spreadsheet has a simple SUM function whereby the contents of a cell (a number) is divided by another cell which contain a total (also a number.) I am …

Hello – I have spreadsheets that I use as invoices to track business expenses for my customers. There are some miles that I charge the customers …

Please help me solve this I need to define OName from a list in the range F1:F25, I need it to use the range to loop through and open each workbook using the …

hello! I need your helpI want to write a code in the VBA that eliminates the CLICK option in a combo box and after I have done some action to enable the …

I have a list of users and their shared mail boxes they use within their departments. There are some mailboxes shared within one or more department …

In cells A1:C1 I have the numbers 8, 3, and 5. In cell D1 I would like to automatically sum the number of combinations like so: …

Hello, First of all, apologies for my inexperience and ignorance – I’m green enough at Excel that I’m not sure even of the words that I …

Hello, I am looking for a way to extract a number from a string or text, symbols and numbers. For example I have the following in A1 …

I have 3-4 cells to work with. I want to be able to have a start value say 100in 1st cell, then subtract 10 in second cell have total of 90 in 3rd cell, then …

Hello. Basically im working on creating something that has a Main Issue which affects the Sub-Issue and then having a Resolution tied to the Main Issue. I have …

Good afternoon. I have a complex formula that I need to build and don’t know where to start with it. i have built an automated front sheet that looks …

So say I have a data of numbers, in A1 I have the value 6, in B1 3, in C1 10, in D1 12, and in E1 9. What I want is to highlight the cells that have increased …

Hi, Firstly sorry if my Excel lingo is a bit off as I’m self taught in Excel. Okay so my problem is simple, say if I had the letters a,b,c,d,e in the …

Hi, Sorry if my terminology is a bit off but I’m self taught on Excel. My problem is that I need to be able to refer to a range/array in a …

I am using Excel 2016 on Windows 10. I want to create a conditional formatting equation so that the cell in question turns a certain color if the cell …

Hi, I have a Macro used at work that concatenates cells A and B for use later when we are compiling data. Cell A has a list of store numbers and cell B …

Hi, Can someone help me, I want the percentages to be ideally a stacked column or bar and the values to be maybe a dot or scatter that appears in the same …

I need to combine a cell based on its “bonus” dollar amount but it is conditional. if cell b4 is red ,because it is below 90%, do not add it to the …

Hiya. I’m trying to make a capacity planner and stuck! I can do part two, but very stuck with part one – It’s probably easier if I …

There are two columns (Name – column A, Number- column B). I need to remove all duplicates except for one. However, if there is ‘Bob’ in …

Hi I am creating a spreadsheet to collect data. I have figured out most problems. But the one I am stuck on is this. I am using a formula …

Hello, I need to replace certain words (which are written in ” “) from SPanish to English As I have over 500 words, I want to automize the …

i want to sum the costs from my journal to general ledger but i want them to come under their own head =ifsum(D4:D20,”D4=A1″,G4:G20) as i have so …

Hi guys, there’s one thing that I wanted to do but couldn’t find any similar case after hours of googling. Here’s the case I have a list of …

i AM DOING A SHIFT WORKSHEET TO SHOW WORKERS THEIR SHIFT HOURS BUT TO ALSO CALCULATE HOURS “LESS” THEIR THIRTY MINUTE LUNCHES TO HELP CALCULATE …

Afternoon all i am trying to include a range of cells from A5 to H27 into the body of the email after the body text. Please help. Sub …

excel if(a3=1,b3,if(a3=2,b4, if(a3=3,b5, if(a3=4,b6 etc up to if(a3=50, b52. Is there a abbreviated formula as a alternative to this long winded oneBy: …

Column 1 Column 2 Column 3 A 100 50 % 100 A half of remaining50% A rest B 231 50 % of 231 B 1/3 rd remaing B 1/3 rd remaing B …

I create a simple excel report for day 1 and customize it (page layout, filter, add formula, sort, color code). Day 2 I create another simple excel …

Abhishek Kumar Srivastava(1002345) –this is the data output want-Srivastava. By: Prabhat

So I have a data set like 1 a 1 e 1 a 2 s 2 s 2 s 2 s 31 e 31 w and I want the output to correspond to max frequencies of text for each unique index. The …

Hello, I am not sure this is possible and I have been unable to find this question posed anywhere else but is it possible to use an excel …

Hi, hoping this finds you well. Kindly see the table below, I have some excel data below Vehicle DEFECT Date KAB 336D Oil Leak 3-Jan-18 KAC 340C …

hallo I use this formula to enter an hour and a cell =IF(D2>1,IF(D3=””,NOW(),D3),””) The formula worked two weeks and now I …

We currently use a Profit & Loss spreadsheet where we have multiple worksheets for differents sites in our company but certain employees are only allowed …

I want hide formula in any cell By:

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.