gurus

Hello, My first post because I usually find my answers without asking :) So here's my issue: I'm trying to create a formula, using IF Function maybe??, that copies certain cells from one sheet to different cells in another sheet and change a cell value on the first sheet, but the cells are...

Hello Gurus, Need your help with the following: Table 1: Has the following values <tbody> Date Employee Value Numbering 2019-05-15 12345 10 Fill this row 2019-01-04 11111 1 Fill this row </tbody> Table 2: has the following values with a start date and end date as a range and...

Hi Mr. Excel Users, Imagine that we have 1:1 is header 2:300 is rows (source data) 299 rows... from 2:300, in column A i need to create a formula that will tell me the 13% sample size of that 2:300 in column B. 299 * 0.13 = 38.87 rows in column A should have marked "Sample/Audit" if we would...

Hello Guru's ALT + ENTER and some spaces NOT IN VBA! What are the disadvantages of this neatly coding in Excel formulas, aside from I have to manually type the spaces? =IF( COUNTIFS( P23:P40,">="&NUMBERVALUE("04/01/2019")...

Good Afternoon Excel Gurus, Need help from the gurus with a quick formula to achieve the following result. Column A has Names that I am trying to change to match the results as shown in column B. <tbody> A B A1 INSP-6 INSP-00006 A2 INSP-16 INSP-00016 A3 INSP-116 INSP-00116 A4...