simple

Hi, Any ideas why this simple formula wont work: =IF(COUNTBLANK(I10:J10),"",NETWORKDAYS(I10:J10)) ? Many thanks

Hello, Good day Mr. Excel users! Sheets("OB Raw").Activate Above code works fine. Sheets("OB Raw").Activate Sheets("forBacklog").Activate When I add Sheets("forBacklog").Activate, it doesn't work. But if I run below code, it works just fine. Sheets("OB Raw").Activate...

Hey all, First time poster here, but i've lurked on the site for a while. I'm looking to import an XML in to Excel but i'm having issues with it. I've used the Import wizard and feel like i'm most of the way, but i'm missing something probably simple. The XML is a few hundred records and has...

Hi, Beyond new to VBA and macros. I'm trying to put together some simple code to loop through all sheets, excluding sheet 1, to format a varied range of cells in each sheet (if the cell has text, format it). I've been reading through all the forums and it seems like it should be simple. But...

Hi, If this isn't appropriate, please forgive me and let me know. I have a small business and am looking for a simple solution to taking inventory at the end of my season. I would like to be able to scan barcodes to enter the info. I would also like to be able to scan an item 3 times, for...

Hi all, Sure this is simple for an expert. Below is the formula to return the value of A3 if the values in row C add to zero. =(IF(SUM(C3:F3)=0,A3,0)) How do I sum the total of all of all the values from A3:A15 that meet the criteria using relative cell references for column C criteria? Thanks!

Hello, I am attaching pivot table with a problem that I didn't manage to solve. I need to summarize amounts per document number and I did that. What happened on the line with Doc No. P1900101? Here is the file: https://drive.google.com/open?id=1jaOIe3mefMLBveOo5VLG1W01BAsFZgw3 I would be...

Hi all, What i am looking to do seems simple enough but i just dont have the expertise to figure out the VBA for it, any help would be greatly appreciated! I would like to evaluate a cell (B7) where if the value = "SUN" or value = "SAT" and then clearcontents of range B9:B37 if that value...

(Excel for Mac 2013) I'm sure there is a simple solution: I am adding up every other cell in a horizontal row (A1+C1+E1+G1+I1) and totaling the numbers in these cells in cell K1. In cell C1, there is an =IF(AND fx that results an integer, but when I add cells A1+C1+E1+G1+I1, the fx result in...

Hi, In a module, I have the following: IF Sheet4.Range("TheList_CountBlanks").Value > 0 Then Msgbox "Helpful message." Exit Sub End If That range name uses the function COUNTBLANK on a simple range and is successfully used in formulas. But that code keeps blowing up with that error. What...

Hi, I have multiple (hundreds) of archived spreadsheets consisting of the same mix of tabs and content format (only the data is different). I want to add an extra tab (lets call it 'Tracker') to pull bits of data from the various tabs into one easy to copy n paste column. Simple. :) What I then...

Hey all, feeling very dumb here. I'm trying to make a simple userform with one textbox, and when the user hits the "Retire" button it will input the data from the textbox into a specific cell (B14 in my case). This feels very simple and I've done it before, but for some reason I can't get it to...

Hi all, I think this is probably quite simple, but google searches are bringing up something slightly different to what I want. I have an accounts sheet, columns A-C are income, E-G are outgoings. I want to sort income by date, which is column A, and the outgoing by date, which is column E...

Hi all, Could you please help me with a VBA that copies row 500 from every sheet, to "Central" sheet, starting with A2? I know it should be simple, but i just can't get it to work... Thank in advance.

I try to keep my formulas as simple as possible. Here is my current formula for finding a match in two columns: {=SUM(IF(F$24:F$43=F44,$D$24:$D$43))} The issue with this is that it sums instead of just reporting the value. Which is a problem if the results are not numerical. I tried this...

Hi guys, i feel like this should be simple but i have no idea how to do it, would love some help. Consider the table below. I need a new column on the end with a formula that provides the maximum value from the position column that also has a 1 in the place field for all records with the same...

How can I go about creating a subgroup listing of the top 2 The data Name a a b b b c c d d d d output to starting range("G15") Top 2 D = 4 B = 3 Even the simple stuff sometimes seams difficult

I'm trying to write a formula that would check a single cell to see if it contains a number. If it does, it will return 1000, if not it returns an #N/A result. To start, I've written the following simple formula just to let me know if the cell contains a number, but for some reason it doesn't...

Hello, I am trying to solve a problem a colleague is having with a simple pivot table. She has two data elements "Den Rsn Code" and Description. She has two sum values: Count of Den Rsn Code and Sum of Total Balance. The table is in tabular format. We are using Excel 2016. We cannot get...

Hi all, recently there seems to be a problem in excel where it constantly crashes. I am trying to make it as simple as possible with as few features as possible. The spreadsheet has few "workbook connections" to a local server. When I open data / connections/ they are there, but there does not...