Search results

Thank you. Appreciate it. frank

Hi all, I have an Excel sheet that has hundred of links.. It comprises static and dynamic links. When I converted this sheet to PDF, I noticed that the static links (the ones that begin with “https://”) work. The dynamic links (the one with no HTTPS but may have something like “Big Brooklyn...

Hi all: In the attached Excel Sheet, there are a "Mileage" cell, a "Mileage Rate" cell and an "Amount" Cell. I want to use the "Amount" cell for dual purposes. I want to calculate the Mileage * Mileage Rate, placing the results in the "Amount" cell, only if the "Mileage" cell is populated. If...

Hi All: Attached is a sample file with two columns (Incoming Ticket and Result Ticket). The Incoming Ticket cell is the ‘raw’ data and the Result Ticket cell is desired results, Using an IF/OR or any other applicable operator to get the Result Ticket value, as shown in the sample file, is the...

Thanks. Worked and I appreciate it. frank

Hi all: Below is a formula consisting of two conditions which are: (1) If the value in L2 AND the value in M2 are both blanks, then set the value of the current cell to "No TRD, TPR, HIF" (this works by itself) (2) If the value in A2 OR the value in B2 is NOT blank, then set the value of the...

Perfect. Thank you!

Hi Bosco: Quick question, if I may. The following formula looks at a cell and determines what 4 numbers are, as follows: Code: =IF(LEFT(L2,5)="https",0+MID(L2,MIN(FIND({0,1,2,3,4}+{0;5},L2&1/17)),4),"") Cell L2: https://fluxer.net/request_portal/txmrs/8903/edit Results: 8903 In the following –...

Thanks, Bosco - Appreciate it. The only issue is when E2 contains "https".

I would like to change the formula in A2 in the Report Results spreadsheet, to say "if the first characters (from left to right) in E2 is not "https" or is "", then "". I tried to use the right operator with this formula, but it didn't work. What am I missing? See attachment row 41. I used...

Thanks. Just what I was thinking about. Appreciate it.

Bosco: Thanks a lot. One quick question, in the "Report Results" sheet A2, can the formula (=0+MID(E2,MIN(FIND({0,1,2,3,4}+{0;5},E2&1/17)),4) ) be changed NOT to return #value! if Column E contained a blank? See Attached for what I mean. Frank

OMG, Thanks! You saved me a lot of frustrations! +++

Hi all: Attached is a Sample Workbook consisting of two sheets (1) Report Agenda and (2) Report Results. The Report Agenda is my source and Report Results is my reference. I have a field in Report Agenda (1) called “Tech” which I am trying to “VlookUp” into Report Results (2). But it is a...

Thanks everyone for your feedback! Appreciate it. frank

Thanks Bosco. Perfect. Appreciate it. frank

Hi: I have a string of data with 4 consecutive numbers embedded and would like to extract only the numbers. Any suggestions/help? See attached. Thanks in advance. frank

balabomma I am trying to create and send ent emails to recipients based on the values in an excel sheet. Can you please post a copy of the VBA script you are using? Would appreciate it. Thanks. frank

Thank all. This is working. Appreciate it. frank

Chiro: Thanks. I am now able to enter more than 9 characters. Where does - =(LEN(C2)=9)* - go? Thanks frank

Hi All: I am using the Data Validation function to control the value and format in my C cells. here is the validation: =(LEN(C2)=9)*(LEFT(C2,4)="ABC-")*ISNUMBER(--RIGHT(C2,5)) C2 cell will have 9 characters as follows: First 4 characters will be "ABC-"; The next 5 characters need to be...

Peter: Thanks for the response. I am not sure where "=$D$3:$D$25,$Q$3:$Q$25" goes. Can you please amplify? Thanks. frank

All: I have several columns in my spreadsheet, of which I would like to fill 2 columns with yellow if the value of one of the columns is "P". In the conditional formatting tool, I want to say "if the value in the column Q is "P", then fill Column Q and Column D with Yellow. In the formula (for...

Bosco & pecoflyer: Thanks a lot. this works like a charm. Appreciate it. frank

Thanks pecoflyer. I could get this to work. Not sure I understand it. Can you please amplify a little or place in sample spreadsheet? Would appreciate it. Thanks.