guess

So I have a simple 2-column table; basically just a list of names where each has a corresponding number. Simply, I want to comb through the list and find things like "| Company A | 5 |" and "| Company A Inc. | 5 |" and combine them. I guess this could turn into "| Company A | 10 |" or "| Company...

Hello, I hope you can help me with an issue two colleagues of mine have experienced: they opened a xls file and a 50,000 amount appeared as 50 for both of them. Even when clicking on the cell, the amount was shown as 50 in the bar on the top. The amount appeared correctly for me, so I guess...

Hi there, i have a relatively simple question. I would like a set of data to be double-spaced. There are two columns of data. Here is what the data looks like now: 1 2 3 4 5 6 7 8 etc. And here is what i want it to look like: 1 . 2 3 . 4 5 . 6 7 . 8 (I had to put a "." to...

Hi, This is the first time i work with Power BI and created a "new quick measure" Hours * Cost SUM('DD_BE_QT_SMO_Services'[Cost]) * SUM('DD_BE_QT_SMO_Services'[Amount_Of_Days]) Hours * Rate SUM('DD_BE_QT_SMO_Services'[Rate]) * SUM('DD_BE_QT_SMO_Services'[Amount_Of_Days]) And this works in...

Hi Guys, I thought this would be SO easy, but my rusty excel skills and my age mean I can't quickly work out how to assign time to a time range. If my times are in a one column and I want to know how many fall in say 4/5 different time ranges (i.e 9-12pm, 12-3, 3-5,5-7pm), would I use a...

Hi all, I want to give the user options which are conditional on another cell. For example, in cell B4 is a dropdown of numbers: If number is less than 12 than cell I4 will be grayed out, & be locked. And if number is greater than 12 than cell I4 will be unlocked I guess I have to do...

Hello, I'm wondering if it would be possible to have a formula in a cell to always remember the highest value in a range of cells even when the numbers in those range decrease. It would be something like B2=MAX($A$1:$A$100), but the problem with the MAX function would be that as soon as the...

Hi, I am getting the error "overflow", when I assign a variable of type double a number >32,000. What is going on? dim guess as double guess = 73000 'no overflow error guess = 73 * 1000 'gets an overflow error I remember this error happening in the past.

I have a very simple question regarding the SUMIFS function. I've created a spreadsheet containing all of my store purchases at a local store. Examples of categories are groceries and apparel. I want to sum up all the grocery purchases in June, July, August etc... Here is my worksheet. In...

Hello. I am new to Excel, I am learning it, but I can't do something. So the task is like this: I have to create 1 more collumn in right of "Comitat" named "Ecuson". In that collumn the name from "Nume participant" should be with uppercase(I guess by using function UPPER) but it should have...

Hello, I know this is a common error but can't see a reason why I receive such error: .Range(.Cells(2, Date_Column), .Cells(LPF_LastRow, Date_Column)).FormulaArray = "=MAX(('Data Base'!B$2:B$20000=B3)*('Data Base'!C$2:C$20000))" It doesn't reach 255 character I guess. When I do this with...

Really do struggle with this I have this formula which equals 21 =MATCH(Table11[[#Headers],[CTZ3]],Overseas!$A:$A,0) I need the 21 in the following to be replaced by the first formula =SUMIF(Overseas!$4:$4,[@[Week Commencing]],Overseas!$21:$21) I guess it's INDIRECT but that's where my...

Hey All, Got a quick question.. I have two sheets in which I'm trying to combine. The only constant is the URL.. I'd like to bring 7 columns of data over from the 'table' into the master sheet. Any way to do this without writing a new function in each column? Absolute values are cool, too I...

I have the following table: <tbody> A 2 B 3 C 5 D 5 E 1 </tbody> I use the following formula to find in col A with highest value in col B: =INDEX(A$1:A$5;MATCH(LARGE(B$1:B$5;1);B$1:B$5;0)) Result =C. Now, to find the second largest (D) I use the same formula, where the argument in the...

Hi guys , Im strugling with string that have same meaning but different spelling , here is a sample string1: MFK Ruzomberok string2: Ruzomberok I need to figure out a way to count the number of different letters , I guess difference in these two strings should be 4 , but anyone know I ninja...

Hello, I'm getting an XIRR of 0 for an investment that is at a complete loss (so instead of getting the correct answer of -100%). My formula is simply =XIRR($D$31:BB31,$D$26:BB26), which refers to the relevant dates and cashflows (about a 6 year period,with an aggregate of $6.5m invested at...

I am trying to change the attributes of a worksheet so that it can be edited. When I'm in the VBA editor and stepping through the code, when the code hits the SendKeys line, it wakes up the Object Browser, which is also listenig for F2 i guess. Can I get a clue as to what am i doing wrong? is...

Hi, Can VBA to check all the charaters including symbols to see if it matches range("A1").character/symbol. Suppose i have "?" in A1, can i make the vba to try entering all the characters or symbols available in B1 and then see which one matches A1??? Or do i have to list symbols...