excel function

I can usethe countif and sumif functions in case of 1 range. But there are 2 ranges wherewithI have to work and I don’t have any idea. I would like to collect the uniqueconnect between elements of two ranges, count how many are them and how much isthe total of their values. See the example. Can...

The sample text data in my sheet are like the following, example Peter England, * Shirt / UK in a single cell. I need Peter England in a different cell Shirt in a different cell UK in a different cell. I am using the following function B1 =LEFT(A1,FIND(",",A1)-1) for getting Peter...

Hi Guys, I have a keyword data dump that has 2 of every keyword (one has data for desktops, one has data for smartphones) I would like to write a vlookup formula that will first check if the keyword is "desktop". If so, pull the corresponding rank (which would skip over the smartphone rows)...

I need to include a function in my C2 cell formula that will skip days with non-zero values and then list the next non-zero day (the day is also listed N times based on Col B value). <tbody> A B C 1 Mon 2 Mon 2 Tues 1 Mon 3 Wed 0 Tues 4 Thurs 0 Fri 5 Fri 1...

Hi Everyone, I am looking for advise on how to analysis sales targets and commission on daily bases. The table below is the one I had for a month but I would like to do break down on daily bases to track activity of my team on daily and weekly bases as well grant compensation...

Hi Everyone, First, a bit of background. I have access to a database that provides me with engine status codes for a vehicle with a time stamp. This engine status code is in decimal, but needs to be converted to binary to be read because each engine status (No Engine Speed, Engine Derate, and...

Hey Guys, I am very new to creating functions using Microsoft VBA and hence need your help for the same. I want to create a function which should perform the operation mentioned below. Function IDW(StartValue, EndValue, CurrentPoint) IDW = (StartValue * (Row(EndValue) - Row(CurrentPoint)) +...

Hi all members, I need your help, Check pic below: Before: After: I want the data: First Min_ab001 then Max_ab001 Then Min_ab002 and Max_ab002 and so on... Please Help me if anyone knows a method.

Dear friends, I have an Excel workbook and an Access DataBase which contains data: DATE | DATA1 | DATA2 | DATA3 I need to write a function like this: MYFUNCTION( CR1, CR2) Is it possible MYFUNCTION to get data from the Database? :)

Hello, I have a set of data as given below <tbody> A B C D E 1 X/Y 1 2 3 4 2 10 1.1 1.3 1.5 1.8 3 20 1.5 1.6 1.7 2 4 30 1.8 2 2.5 3 5 40 1.9 2.5 3.2 4.5 </tbody> Another table is to be filled by interpolating from the data above. <tbody> F...

Hi All, I have a fomula field in row 67 and 68 .Row 67 calculates the average and row 68 calculates the improvement i.e. average(row 68)- last row inserted(row 67). The values for improvements are not showing correct value. C68 seems to give correct value but B68 and D68 is giving wrong value...

When I inter this text any column and row this is convert =Zeyran to #NAME? If i also write =Emma this is convert to #NAME? Any =text change to #NAME? I don't want this change plz help me how to disable this system in excel column. <tbody> </tbody>

Hello, Is there a replacement for NUMBERVALUE function from Excel 2013 to be used in Excel 2010. Whenever I open it in Excel 2010 it shows as _xlfn.NUMBERVALUE and gives #NAME error. So I need a function which does the same job and is compatible in both EXCEL 2010 and 2013. Thanks.

Hello everyone. I just a have a general question about using the IF function to display matching names. My spreadsheet looks like this <tbody> edcoronado edcoronado123 joel joelsmith don schmit donschimt4523 dansmith dan jones The above is in the A and B cells...

I'm currently making an excel file for someone. But I'm quite stuck. Here's the problem. <tbody> Size Quality order supplier order customer Stock 5X5 High 200 150 50 5X5 High 50 50 50 6X9 Low 100 25 75 5X5 High 0 50 0 </tbody> I can't find the formula for stock. It MUST check size...

I am looking for a way to automate this process. The table in the file marked as Actual depends on the first two tables Vol and Budget. I need an idea of how to automate the process. Here is a sample file - https://www.box.com/files#/files/0/f/0/1/f_2514961751.

I have data with a lot of rows and 7 columns. I then want get the largest number of all the numbers in column 1 where the cells in column 2-7 match certain criteria’s. So if the cells in column 2-7 of a row don’t match the criteria’s, the number in column 1 of that row should not be accounted...

hello, i am wariting a vba code where i am calling a function again and again. Is there any way i can avoid writing it again but call in a loop. your suggetsions would be highly appreciated. thanks in advance. Call InputSubLoop(1, Range("A1"), Range("B1")) Call InputSubLoop(2...

Dear all, I have a question about a case in excel. I am doing a research with the following information. In column A, I have the name of the buyer company, column B name of the different purchased companies marked in yellow,blue or green depending on certain characteristics. I would like to...

Hi At our lab we use protected worksheets to calculate analytical results ranging from 0,00001 to 1000000. In order to allow the users to change the number of digits, that they want for a given set of results, a cell - e.g. A1 - is left unprotected for the entry of the desired number of...