Search results

Hi again, Thank you everybody for being kind. It helps me go through my relationship with excel a bit better everyday. I have this formula (='Test.xlsx'!$E$14) to return the value of another sheet's cell. My problem is whenever the source cell is blank , it'll return 0 and if the value of...

Hi, Can you give me an idea on how to compile questionnaired in one workbook with the format in the consolidated excel file found in belows link:https://docs.google.com/folder/d/0B8ipP_XUVnFwRXZ1aHhFYV9PY0U/edit Thanks.

Hi All, I am just wondering if this is ever possible. :( I have been trying my best to make this as easy as possible for 2 weeks now but the only thing that would work is to manually do it. I have been tasked to send a report based on the following requirement with only these column...

Hi, It's me again. I need your help on calculating the service level if it passed or fail based on a requirement. So far, I have only managed to create this: =IF(O:O="","", IF(AND(D:D="SL 3",O:O<=TIME(12,0,0)),"Pass","Fail")) This works for one argument but if I do nested if, it does...

Hi All, Since , I came across this forum, I have been really encouraged to teach myself VB scripting to do Macros and other things, pick up another skill but the problem is I do not know where to start. Please recommend any site or books that I could read to kick off my self study. I am a...

Hi All, I need your help because I am new to this job. I have a table (figure 1.1) and I need to arrive to a result for my weekly report (1.2). I have tried pivoting but I cant count the 4+ weeks. This report format was given by my boss. Please see example below...