excel formula

I am looking for a simple VBA code to Delete lines in cells starting with an alphabet. In each cell in column c, there is a multiline text starting with numbers, special characters, and words. I also delete the space before them if any. Some cells are empty.

I'm stuck! I've been trying to figure this out for hours now. I have the following formula below: =SUMIFS('July - Present'!O:O, 'July - Present'!A:A,">="&DATE(2021,10,1), 'July - Present'!A:A,"<="&DATE(2021,10,31), 'July - Present'!Q:Q,"", 'July - Present'!R:R,"", 'July - Present'!S:S,"") The...

I’m trying to link the square footage on the Taxes worksheet to the lot number (G8 on sheet1). That way, when I enter the lot number on G8 it automatically pulls the corresponding square footage into the calculation on the taxes sheet and puts the result in cell G41 on Sheet 1. Thanks!!!

Hi Gurus, Any thoughts on what would be the right sumif lookup formula for below scenario? Sheet 1 - I have a long list of Data. Simple example below: Name Change Sam 250 Mike 300 Sam -500 Mike -150 Sam -50 Mike -25 Sheet 2 - I'm having a hard time doing it in pivot so just...

Can we build a single formula to auto-populate the list of dates as shown in column 'G', based on the payment cycles set in (i) & (ii) and the list of dates provided in (iii), without repeating common dates between them? For now, I prepared separate list of dates using formulas to calculate...

Hi Friends, I looked some posts over here on how to extract words before closed backets and based on number of characters/letters within closed brackets. I am looking to do this with formula/vba/udf. Here is an example Designed and developed the application using Java Server Faces (JSF)...

Hi! So I want to make a Dynamic array with Choose, where one column will be the unique clients and in the second column I want the SUMPRODUCT of Quantity and Price for each product. As you can see the result is 0 for each row. This is just an example of my real problem with a report of 200K...

Hi Guys I have the following formula =IF(H2>=F2,"withinsla",IF(H2<F2,"slabreached")) The above formula works well I want to add the following in the formula if H2=Q2 ,"urgent" Thanks and Regards rakesh

I have a list of past due invoices. I have a PO Date (column f) and I am wanting to add a column for Aging Days (column H) that will tell me how many days have gone by from the PO date. In column I, I would like it to tell me if the invoice is past due or not past due. Any help would be...

How to Highlight cell Text After MATCH With Paragraph in Text / Number ???? Make alert Status ??? EXAMPLE : Like Certificate Number & Date Matching With Paragraph Text , I try Match Condition Text With Paragraphy Both Text Are Match : Condition Show is "TRUE" Both Text Are Not...

Hello every one .. If i have a data set like this one in the attached picture , Is there any way to find the positions as a result in column "P" by finding the the smallest values in column "O". Notes that there are a duplicated smallest values in different positions in the data set.

# HOW TO WORK THIS FORMULA WITH DROP-DOWN LIST i try target this Drop-down list but not working my Index+match formula .... pleased help this ......& Do Correction my formula.....

All Number list is Same Len ,if Number After Single Space , We Need Only TEXT Contain ,How to possible in EXCEL formula .......

I have this if statement that calculates a due date for me, it works fine but I now have a new situation that created the need to modify to exclude the calculation if column E contains the work "Broker". =IF(K21<>"","N/A",IFERROR(WORKDAY.INTL(N21,-3,11,Holidays!$D$5:$D$26),"")) Here is what I...

I have a spreadsheet in which I dump some data from SAP, which ends up looking something like this I then insert a formula in J2 which is supposed to find the latest date / month there is a registration for. However, it doesn't seem to be able to interpret values in column D as dates. What...

My laboratory is capable of running 20+ different analyses, and we get contracts from about the same 15 companies to do a combination of these analyses. I created an Excel spread sheet to keep track of the work as it comes in, where columns are the 20 different analyses we can run, and rows are...

Condition-1 Match List-1 & List -2 Number & Show result in list-2 "item" Cells........

I have a column that uses VLOOKUP to bring in values from another sheet. I would like to save the precious value of any cell in this column to the corresponding cell in the next column whenever the cell value has changed. Example: Current values: Cell A1=1, A2=2 If VLOOKUP brings a different...

Hi, We manage admissions data back-end. Our applicants go through interviews with 2 interviewers and this data sample is automatically populated using MS forms and Power Automate. However, this is what we need for the compilation of data in our mastersheet. For every 2nd interviewer, we...