solve

Sometimes I want to sort numbers in a pivottable with the right mouse click ascending / descending. Unfortunately this doesn't work most of the times. Who knows the possible reason and how to solve this? Thanks. Best regards.

So I started off thinking this was "easy"... I have two values and need to find the best match and return a result (3 columns) Input 1: Distance (Actual) Input 2: Capacity (Needed) Column 1: Distance (Max) - Need to solve for closest larger than (Can do separately) Column 2: Capacity...

<colgroup><col style="mso-width-source:userset;mso-width-alt:1080;width:23pt" width="30"> <col style="mso-width-source:userset;mso-width-alt:568;width:12pt" width="16"> <col style="mso-width-source:userset;mso-width-alt:3100; width:65pt" width="87" span="6"> <col...

Hi All, It seems an old question. I found so many posts regarding the same. But couldn't solve the error. I am trying to save my Active Sheet into a PDF using the following code. Initially, it worked fine. But recently it shows Run-time error 5. "Invalid Procedure Call & Argument". Please help...

Hello, I have a problem, maybe it's simple but I'm not able to solve this, thats how my sheet looks like: <tbody> Name Jobnumber Sandro A801336.00 Alex A801233.01 Sandro A802444.00 </tbody> In Cell "J" I'm using this Formula to read out a specific value...

Range(Cells(i,"b"):Cells(i,"c")).Select Unfortunetely it's not correct. Could you help me to solve this?

Dear all, Feel thankful to find this forum. I'm not an excel expert, nor a math expert. But recently I have to find the X value with this equation: Y = 0.0000302307X^6 - 0.0017620175X^5 + 0.0376232469X^4 - 0.3880372117X^3 + 2.3962783035X^2 - 3.6979108034X + 1.4580209629 I have a series of Y...

Hi guys, I use that formula =RANDBETWEEN(MAX($B$2,$A$2-(($D$2-ROWS($A$4:$A4))*$C$2)),MIN($C$2,$A$2-(($D$2-ROWS($A$4:$A4))*$B$2))) But i get some error like that. I can not solve this problem :/

I'm trying to write a formula to solve for X in the image below. I want to know how many 5-star reveiws a client would need to get to an average of 4.5 stars if they already have 6 reviews averaging 4 stars. Any suggestions? It's driving me crazy because I was never too good at algebra.

I'm a student at Macquarie Uni and trying to solve a problem relating to project finance. I'm unable to understand how to solve for Refinance Upfront fee. My lecturer states the following "The refinance fee should be calculated on the refinanced amount, inclusive of the drawdown for the...

Can someone help me solve this.. I'm stuck :(

I am having trouble with a formula and cant seem to figure out how to solve for. I am trying to solve for a commission Plan. The Logic is if the Plan type is equal to A and the term of the contract is =<12 months than put Plan type A1, if equal to A and >12 months but <36 than apply plan A1A2...

Hi! Sp this is not exactly excel related but somebody might have an idea. When we use Adobe Acrobat to convert a perfectly normal PDF report into Excel, some of the top rows on pages don't get added to excel. This happens randomly. Once it was 4 out of 11 pages, once it was 22 out of 67...

Hi.. I have 5X5 array table. I would like to know the project name, if one who save hours in the corresponding project. for an example if i am selecting the name Name E from drop down list, the output supposed to be <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>...

Does anyone know how to code in whether or not a cell begins with a number or a character? I pulled this from an different website, but doesn't seem to solve my problem: =IF(ISNUMBER(VALUE(LEFT(Q2,1))),"Non-Alpha","Alpha") Thanks

'=IF(AH1=AL1,OR,AH1=AM1,OR,AH1=AN1,"YES", " ") So I'm trying to find a YES if any nunbers in AL1 or AM1 or AN1 match the number in cell AH1. The numbers found in AL1,AM1 and AN1 will always be different. I've researched "OR" but have found only examples that do not include "find any that...

Hello every one. I try to make a dependent combo box but are not be able to solve my difficulties. That its not dependent.

Hello, This one is a bit hard to explain and even harder for me to figure out a solution in Excel. Cell A1 = 3 Cell B1 = 5 Cell C1 = .25*D1 Cell D1 = SUM(A1:C1) In algebra it would be... A1 + B1 + C1 = D1 where C1 = .25*D1 thus... A1 + B1 + (.25*D1) = D1 where A1 = 3, B1 = 5 and solve for...

Please i'm having problem of changing my Orientation (landscape or Portrait) on page layout is not changing hw do i solve it

<tbody> Patient T1 T2 T3 V4 T5 T6 T7 T8 V1 1 5 1 6 1 7 2 10 11 15 16 17 3 14 3 15 4 11 5 18 5 19 </tbody> i want all result in perpenducular <tbody> Patient test result 1 T1 5 1 T2 6 1 T3 7 2 T2 10...