I have a data table like so:
a 1
a 2
b 3
b 4
c 5
c 6
c 7
I want to pull items out of this table by dynamically telling it what letters to pull. My current formula is: =query(A1:B7,"select * where A ='" & D1 & "'"). D1 being the cell I wish to modify to modify the query. I want to be able input into D1 -- a, a,b, a,b,c and have the query…
Hey guys,
Just a warning: I'm completely new to Java and am trying to teach myself Android programming.
I installed the Eclipse IDE today and tried to walk through the first Java Hello World "cheat sheet," and it didn't work! I was really quite surprised.
When it asked me to select the checkbox to create the main() method, there wasn't anything…
Does anyone know of a good overview of the different C# collection types? I am looking for something showing which basic operations such as Add, Remove, RemoveLast etc. are supported, and giving the relative performance.
It would be particularly interesting for the various generic classes - and even better if it showed eg. if there is a…
At our WebLogic Community Workspace (WebLogic Community membership required)
you can find the latest sales plays to update your sales team. Kits
include a overview presentation to train your sales teams, cheat sheets
for your pocket and customer ppt presentations:
WebLogic 12c FY15 sales resources
FY15 CAF Sales…
In Excel 2007, I have a sheet full of data "A". One of the columns in sheet "B" is called "Valid" and has either "yes" or "no".
I've created a second sheet "B". It's easy to make each row in "A" appear in "B" if the row is valid using an 'if' statement in each cell. But if it's invalid, there's a blank row.
I need "B"…
I am making a simple card game in unity. The game is based on a standard 52-card pack, with identical backs for unique faces. In my particular game different cards are worth different values and have various special abilities. The game will have 52 cards on the table (on the draw position or in the face-down deck or in…
Hi
I am reading the Excel sheet in c# using interop services. My excel sheet have the date columns of formate dd/mm/yyyy. while reading , runtime i am getting some different values for each cell as :38840,38808,39873...so n so... what does that mean? please help.How to handle the date columns of the excel sheet in C#.…
I want to add the action sheet in cell of table view, i want when i click on the cell of table view the action sheet should come and after i click on the the option in action sheet, i want to go to the next view.
Hello,
I am trying to use SpriteSheet to run an animation. My frames are of 320x480 in size each, So I am able to put max 6 frames on the texture image. But my animation consists of frame number ranging from 50 to 200 sometimes, and all are of size 320x480.
But this much number of frames cannot be added on the Texture…
I use Delphi 2010 . I am useing twebbrowser to load up HTML source and view .
Now I want to click on an area(Background, Links,etc)
in the webbrowser and get the styling in the CSS file that styles the HTML.
Example I click on the H3 region and I want to be taken to the h3{ color: white; } in the CSS.
Any help at all…
I'm looking for something similar to Pacman Rosetta, which explains how to achieve similar tasks using different source code management tools.
Sometimes docs for a certain SCM contain examples comparing that particular SCM to a couple of others. But I'm looking for a central place that contains maximum available…
I have a lot of Excel sheets for all sorts of things - but none has ever acted up like this one here:
This used to be a totally normal Excel 2007 sheet which I was able to resize, maximize etc. - but not anymore. What happened? What can I do to "undo" whatever I did to it.
Any ideas?? I tried to share / undo…
I search for a way that allow me read all history data from Google Chrome history and save it in any format for example excel sheet .. but i want a way in which i make it by copy data from page and paste in a sheet and formating it .. i search for automatic way or a tool ?
I currently am working on a project which has one large style sheet for about 20 pages. The style sheet contains some styles which are specific for certain pages. I'd like to break the style sheet up so there is one style sheet for each page with one master style sheet that handles everything generic. The reason…
im building a pretty large website that will have many pages and folders. I have 1 stylesheet.
How do I add the style sheet to "ALL" of these folders? I didnt have this problem before I started to put the pages in SEPERATE folders. Now that each page has its own folder it no longer reads my stylesheet unless…
I have created a sprite sheet with zwoptex. Then I just dragged the .plist and .png files to my Cocos Builder project. After this I wanted to take a sprite frame and set it to a sprite:
But the sprite image is empty! At first I thought it was just empty in Cocos Builder, and that it must have been…
In one of my community projects I needed to output some listings as Excel file. As installing Excel to server is non-sense that I was easily able to avoid I found simple solution for Excel 2007 files – open-source project called ExcelPackage. In this posting I will show you hot to create simple event…
I am looking for some help with a VBA solution for preserving hyperlinks when using VLOOKUP on Excel (2010).
I have a load of data on Sheet 1 for internal use only, and a cut-down version of this on Sheet 2. Instead of recreating Sheet 2 everytime, I am looking to have a working version which…
I don't get it. Why is it so complicated to create a bootable usb from a disc image?
Disc images have boot sectors, so why can't you just write the raw LBA values from an image directly to a USB and be done?
I haven't see any tool for Windows that lets me do this.
I have an original sheet that has over 39000 lines in it. I knocked it down to 1800 lines that I want to improt into my database, however. The Dumb#$$ that I am, I selected only the visible cells and killed like 10 columns that I need.
Is there a way to compare to the original sheet using a…
Dear friends,
I got a program from
http://kousenit.wordpress.com/2007/03/27/groovyness-with-excel-and-xml
but I got some very strange results:
1) I can still print xml but two records are not readable.
2) I got exception suggesting some thing missing
could some experts enlighten me about…
I want to restrict users to entering either just 0 or 1 in an Excel 2007 sheet.
I use the Data Data Validation dialog to do this, but I'm finding that it doesn't stop them from entering blanks.
What I would like is for there to be a prompt when they enter blanks, just like the one that…