require

Hello, How do you protect a given worksheet so that a password is required even to view the worksheet? For example, suppose you have a workbook with four worksheets and you want the viewing of any given worksheet to require entry of a corresponding password (or a master password) as shown in...

Hi Excel Experts, I need to customise the Sumif formula here...if you look at the below table..typical sumif will give the require numbers however, I should get the sumif results at once not at every line where we have same lines....for example below <colgroup><col...

Hi there, I already have a staff timesheet spreadsheet with a formula to determine number of hours worked (cell D1 below), but require another formula to insert a value for 'break time'; if D1 = 6 or more hours worked, I require the new formula to insert "0.5" in C1. If D1 = 9 or more hours...

I require specific formula for lot wise sum of ID . The ID will re-occur but the re-occurred ID should be separately addition-ed. The ID will be nearly in 2000 number. # Do not sum all the similar Structure ID #Do not change the Structure ID <tbody> Structure ID Weight SUM A 1 A 1 3 B 2...

Based on below data, I need formula to get age band.. Values are in Col E. Output require in Col F. Col E Age band require.. (10-13,14-16,17-20)...

<colgroup><col><col></colgroup><tbody> Col 1 Col 2 7/8 5/8 7/8x 5/8 7/8 5/8 x 7/8 7/8 7/8 x 3/4 3/4 3/4 3/4 3/4 3/4 x 7/8 7/8 </tbody> Hi everyone, I need a helping hand. In my excel sheet, in col1 whenever value changes, i require a expression as shown in col 2...

Hi again, I require a macro to move multiple lines of data into a table style format. The macro is required to keep the first three cells of the row as they are and then repeat down for 41 further lines. Then the next 11 cells to remain as they are, then every 11 cells for the next 41 times to...

Hi there, I posted a similar question a few years ago which proved successful but cannot find the macro script so will post again. I have multiple rows of data which has been taken from a completed pdf and have been merged into a spreadsheet as a csv. I have saved the spreadsheet as a .xslm...

starting date Ending date Formula require to calculate hours..

hi all, I need formula, where lookup values are in two different columns, and with combination of these 2 values I want to find an answer.... I use this formula, but these is something wrong..

Hi, I have catalogued my record collection and wondered if there is any way to find out which Artist's name occurs most in the Artists column, I don't require a count as such I just want to put the name that occurs most in another cell for stats purposes, any ideas?

Hi - I have received a block of data which has surrounded the key information that I require. Let me explain 11111177777777772017-12-11 is recorded in a column called Customer Number I require the Customer Number which the ten 7's, of course they not be 7 as each customer will have a unique...

I need to find the number of months between 2 dates, I have tried "DATEDIF" but this does not give what I require, below is what is needed <tbody> A1 B1 Months 01/01/2017 29/01/2017 1 01/01/2017 01/02/2017 2 01/01/2017 28/02/2017 2 01/01/2017 01/03/2017 3 </tbody>

Hello there, I require in Column R & S only in “DataInput” sheet, when I wrote in cell. w then automatic comes Winner & l for Looser. Require VBA coding. Regards, Rahul

I've got a spreadsheet of a CSV File with an export of products. This has everything i require to port over to another website, however, i do require the url Slugs. So the format of the CSV file will show in Cell D1 for example...

Hi, I want to eliminate everything in left after a word. Example: Suppose I have below number a) 123 # 456 b) 12 # 21 c) 1234567 # 7654321 The output which I require is everything after #, as : a) 456 b) 21 C) 7654321 Could you please help? Thanks in advance.