amounts

I have a long list of expenses, with accounts in the A column and amounts from different business entities in the columns to the right. The last column contains a formula that ranks the aggregate expense amounts. The rows are conditionally formatted so that rows with the 10 highest aggregate...

Hi! Does anyone know if there is a formula for counting the number of amounts between +/-/* in one formula in one cell? If I have a cell with a long, but simple calculation as: =199+25+989+52,5-3849+2658+6598-1,22 (and hundreds more) I'd like in the next cell to have the number of sums, here it...

One of our accounting systems will export amounts with a suffix of " D" for debit balances (positive for non-accountants) and a " C" for Credit balances (negative). Obviously I can find and replace the " D" for my positive amounts, but I need to convert the ones with " C" to negatives. I can...

<tbody> 1 1 1 1 1 2 2 2 2 2 Store Takings 507659 4788131 1922938 1611230 1597516 4097383 1867506 1385749 1363487 1494906 Wholesale 11377 60284 22953 52458 39394 99191 20885 52102 147308 27181 </tbody> I want to lookup a number in...

I have been able to work with these with some success. What I am having trouble with is getting the formula to use more than one column to choose the data from. formula =sumifs(tkcol,tkno,dola,dolb,dolc) where tkcol is the truck range, tkno is the truck to match, and the last 3 will have...

I am trying to create a spreadsheet that balances my clubs books. Debits are in G6, Credits are in I6 and balance is in K6. I am looking for a formula that leaves K6 blank if there are no numbers in G6 or I6; and will subtract any amounts in G6 and add any amounts in I6. Hope this if sufficient...

Hi, I'm trying to find a way to find all combinations that equal a given sum in Excel by either a formula or VBA. I have column A, row A1 through A1750 with different amounts (some are negative amounts) and I need to find which rows add up to the sum of $213,448.63 Please help if you know a...

Ive got two columns, A has amounts and B has set percentages literally "40%", "35%", etc. which all are set exactly 5% apart. I need to see what is the average of all percentages as determined by the amounts in column A, meaning whatever actual is most popular, resulting in a number like say...

Hi, Im using excel 2016, im trying to add i believe an if statement? into a cell but i dont know how to or if its the right statement to add Col BP2:BP20446 contains revenue amounts (different amounts per row) i want column DS to have the result. so if BP2:BP20446 is <100K or between 100K &...

Good day I have a sheet in excel 2010 called Recon It is extracted and saved as Web Page (*.htm;*.html) I would then save it as a macro enabled workbook (*.xlsm) This is my problem Column E is then saved as text showing amounts as R 369,90 and lager amounts as R3 000,00 I need to...

Hi I was wondring if there is a better or faster way to scrape large amounts of data that the one im using ? I genrally run a code like this: Sub somesite() Dim XMLReq As New MSXML2.XMLHTTP60 Dim HTMLDoc As Object Dim HTMLRows As MSHTML.IHTMLElementCollection Dim i As Long, j As Long Dim URL...

I have a huge excel spreadsheet that I have inherited through an acquisition. 32,000 rows with 10 columns. I would like to count some dollar amounts in column "K" based on a vendor name in column "F and a division name listed in column "E". For example if I wanted to know how much money, from...

Hi Everyone, Thought this would be easy so maybe my brains not working today but need your help I have amounts in column G these amounts are broken up using spaces so I would like a formula that I can put into row G that will add all the data above it until it comes to a space (Blank cell)...

Hello I have some experience in excel but not much. My boss at works wants me to make an excel worksheet that we can send out to our clients to determine the amount they will owe us on any job that comes up. Pending on the job amount the client their amount will vary. For example if they were to...

I am trying to make excel give me an amount on a different cell, of a number that I have. For example: My added matched lottery numbers add up to 7 in some cases, 8 in others and so on. I want the cell to its right to tell what the count 11 is. Let me clarify better. The lower counts are...

Hi all, I have found this great bit of code thank you "Tushar Mehta". Is it possible to make it faster by only showing/working out 4 or less combinations any more and it will stop trying and move to next combination? Been on it a while and cannot work it out. Any help would be amazing :)...

I am using Excel 2003. I’ve created a user form to input data into a spreadsheet. My problem is that I can’t “format” comboboxes, text boxes or list boxes on the form<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> For example:<o:p></o:p> I have text...